Does anyone know of any free tools that can assist in converting an SQL2005 database back to SQL200 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.
A:
Have you considered using DTS to transfer the data across? It should be independant of the version.
1800 INFORMATION
2008-09-04 00:59:30
+1
A:
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.
Anthony K
2008-09-04 01:18:20