Reputation: 2603
Does anyone know of any free tools that can assist in converting an SQL2005
database back to SQL2000
format? I know that you can script all the objects and then do a dump of the data, but this is a lot of work to do manually.
Upvotes: 1
Views: 122
Reputation: 2603
Reviewing some other related questions I just found Microsoft's Database Publishing Wizard. It does most of what I need, although I have used nVarChar(max) in a couple of places and it simply fails to handle those cases and bombs out without generating anything.
Upvotes: 1
Reputation: 135463
Have you considered using DTS to transfer the data across? It should be independant of the version.
Upvotes: 0