Last post Jun 04, 2007 08:10 PM by SalmonTraining
Jun 03, 2007 10:42 AM|DKB|LINK
Hi I need to know if any has gotten sql 2000 to work with the personal site. If so what is it do need to look out for besides the connection string.
Jun 03, 2007 11:51 AM|SalmonTraining|LINK
My first rollout was on SQL 2000 but have since upgraded all sites I maintain to 2005. My memory was there were no initial problems with setting up the live site on 2000.
The only issues I recall were due to using SQL Express 2005 on the local environment and migrating data to the live SQL Server 2000. Some scripts I use to upload data had to change to accommodate small differences in tables structures between the two environments.
The moral is to keep the development environment as close as possible to the production environment i.e. i'd advise getting the starter kit working on your local PC using SQL Server 2000 rather than using the default SQL Express.
Jun 03, 2007 09:45 PM|DKB|LINK
I have never installed sql 2000 to vs 2005 I would think I will have to do something manually I have sql 2005 installed with vs 2005 so what will I need to do . I'm thinking that I will need to uninstall sql 2005 and install 2000 or can they be on that same
Jun 04, 2007 08:10 PM|SalmonTraining|LINK
Yes, SQL Server 2000 and 2005 can be on the same machine (this is quite common in corporate environments that don't upgrade everything at once).
You have to watch out for a few things. Firstly, only one server can be the default server. You will need to name explicitly the SQL 2000 server when installing. Then you will need to ensure that your application uses the correct server name instead of relying
on the default server.
Secondly - it's unusual to install 2000 after 2005, I have not personally done so although I've done it the other way. I'm posting a link which shows a discussion on problems using the reverse order - in which one poster suggests removing your 2005 and then
reinstalling it after 2000 but another poster says that is not necessary and has some advice. I strongly advise you to back up all your 2005 databases that are important to you before installing 2000.