R2i DotNetNuke® Forum

R2i wants you to have the opportunity to ask questions, post reviews, help others or just rant and rave about DotNetNuke® or any of the R2i Modules and Skins. Our team spends hour upon hour, day after day, working on custom DotNetNuke® modules and services; please feel free to ask us anything.
 
Upgrade from sql server 2000 to 2005
Last Post 08 Jul 2010 11:17 AM by jeklina11. 2 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Not Resolved
mandrews1234User is Offline
New Member
New Member
Posts:1

--
06 Oct 2009 09:54 PM  
We had a dot net nuke site running under sql server 2000. I backed up the 2000 db and created a db in 2005. I then restored the db in 2005 with the 2000 backup. The db restores fine, but when I point our site to the 2005 db I get the site is under construction page. Any ideas on how to fix this? Thanks,
jeklina11User is Offline
New Member
New Member
Posts:36

--
08 Jul 2010 11:17 AM  
Microsoft SQL training is important to learn all about the different versions of this program. And, once the class is taken it is important for technicians to continue their education when new versions of SQL are available. For example, SQL 2005 training is necessary for techs to understand all the ins and outs of the Microsoft SQL Server 2005. It is worthwhile to take SQL 2005 training classes because it keeps you up to date and improves your income. When you take a class of this nature you will learn about some of the key features of Microsoft SQL 2005.

T SQL, also known as Transact-SQL is a variant of SQL and is used in the Microsoft SQL Server. This additional syntax helps in stored procedures. TDS, Tabular Data Stream, is what both Microsoft SQL Server and Sybase/ASE use to communicate. This was also incorporated into the FreeTDS project so that more Microsoft SQL Server and Sybase databases could communicate. The most recent version is SQL Server 2005. This supports the connectivity to Web services SOAP protocol. What this means is those clients that do not use windows can communicate across the SQL Server. There is also a certified JDBC driver that was released by Microsoft that allows Java applications to communicate to the Microsoft SQL Server 2000 and 2005.
SharePoint Consulting
jeklina11User is Offline
New Member
New Member
Posts:36

--
08 Jul 2010 11:17 AM  
Microsoft SQL training is important to learn all about the different versions of this program. And, once the class is taken it is important for technicians to continue their education when new versions of SQL are available. For example, SQL 2005 training is necessary for techs to understand all the ins and outs of the Microsoft SQL Server 2005. It is worthwhile to take SQL 2005 training classes because it keeps you up to date and improves your income. When you take a class of this nature you will learn about some of the key features of Microsoft SQL 2005.

T SQL, also known as Transact-SQL is a variant of SQL and is used in the Microsoft SQL Server. This additional syntax helps in stored procedures. TDS, Tabular Data Stream, is what both Microsoft SQL Server and Sybase/ASE use to communicate. This was also incorporated into the FreeTDS project so that more Microsoft SQL Server and Sybase databases could communicate. The most recent version is SQL Server 2005. This supports the connectivity to Web services SOAP protocol. What this means is those clients that do not use windows can communicate across the SQL Server. There is also a certified JDBC driver that was released by Microsoft that allows Java applications to communicate to the Microsoft SQL Server 2000 and 2005.
SharePoint Consulting
You are not authorized to post a reply.

Active Forums 4.1
 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seatle, WA • 410.327.0007 • info@R2Integrated.com

Bookmark & Share Bookmark and Share