<p>Does anyone know of any free tools that can assist in converting an <code>SQL2005</code> database back to <code>SQL2000</code> 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.</p>

[{'answer_id': 42958, 'author': '1800 INFORMATION', 'author_id': 3146, 'author_profile': 'https://Stackoverflow.com/users/3146', 'pm_score': 0, 'selected': False, 'text': '<p>Have you considered using DTS to transfer the data across? It should be independant of the version.</p>\n'}, {'answer_id': 42983, 'author': 'Anthony K', 'author_id': 1682, 'author_profile': 'https://Stackoverflow.com/users/1682', 'pm_score': 2, 'selected': True, 'text': '<p>Reviewing some other related questions I just found Microsoft\'s <a href="http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard" rel="nofollow noreferrer">Database Publishing Wizard</a>.  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.</p>\n'}]
['https://Stackoverflow.com/questions/42954', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1682/']