CODEWITHSUNDEEP
sql-serverdatabasesql-server-2005
Anthony K
Anthony K

Reputation: 2603

Backward Converting SQL Databases

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

Answers (2)

Anthony K
Anthony K

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

1800 INFORMATION
1800 INFORMATION

Reputation: 135463

Have you considered using DTS to transfer the data across? It should be independant of the version.

Upvotes: 0

Related Questions