Clever Geek Handbook

How to migrate a database from SQL Server 2008 to SQL Server 2000

I am replacing an Access application with a web application, but the client is using SQL Server 2000 and I am using SQL Server 2008.

So I have a database refactored with foreign keys, but now I need to get the data on the client system.

The problem is that they have images with more than 32k, so osql failed when filling the command buffer.

I have to use osql to import the new schema at least and probably for all data except images.

The export wizard just won't work, although I tried native SQL driver and OLE DB Sql driver.

Flat files seem like a bad choice since I don't know if it can do images.

So what's a good way to copy a 330M database from 2008 -> 2000?

+2


source to share


2 answers


I set the image column to zero, which reduced the size of the insert statements.



This allowed me to import the data into the target database.

0


source


Not sure about performance or timing, but you can always try a tool like



This will allow you to compare both the schema of the two databases and the data, and also let you create sync scripts or sync online.

Mark

0


source






More articles:


All Articles