Question about moving from a MSSQL 2000 to MSSQL 2008 database
Posted by user471, 03-03-2010, 04:47 PM Hi, I have a site that stores it's data in a MSSQL 2000 database. The site is written in classic .asp I am looking to move to a different host. The new host offers MSSQL 2008. What is the best way to get the data from one db to the other? Thanks Chad
Posted by avizzle, 03-03-2010, 06:25 PM Have you considered updating your code base? Classic ASP is quite dated. Although I've never gone from 2000 to 2008, in theory you should be able to simply dump your tables and import the data into the 2008 database. Load up your SQL Manager and have at it. Off topic, but MSSQL has always scared me to a particular degree. It seems far more complicated then it should be (typical MS scenario), and the prices associated with it makes me wonder how they can live with themselves.
Posted by accwebworks, 03-03-2010, 08:59 PM For the most part you should not have any problems. You can do it straight from SQL Management Studio. If you have sql 2000 specific functionality in your stored procedures, you may have to rewrite some of it. It all depends how straight forward your sprocs are.
Posted by gotlivechat, 03-04-2010, 10:50 PM We did a 2005 to 2008 and it was pretty straightforward. There were a few minor errors easily corrected and haven't seen an issue with MS SQL Server since. But definitely testing the scripts is important!
Posted by RoboHostCo, 03-06-2010, 08:24 PM At my job we recently changed our production database server from SQL 2000 -> SQL 2008. The move was really not that bad. All they had to do was detach the database from the old server and reattach it to the new server. In SQL2008 we have the compatibility level set to SQL2000 so we run less of a risk of breaking any existing stuff. This is a very major corporate database server which we where running and it was a very smooth switch.