Geeks With Blogs
Razi Syed Professional Developer

Is it just me, or did Microsoft completely screw up the data conversion utility in SQL 2005? I do a lot of conversions from SQL to Access, and the one in SQL 2000 worked perfectly. In 2005, I ALWAYS encounter stupid errors... either in pre-Execute, or prepare for Execute or when it is actually executing... What is the point of having all these useless steps anyway? Also, the converter in 2005 is extremely slow!

It frustrates me so much that they threw away such a nice utility that worked perfectly in 2000, redesigned it completely just so that it won't work anymore :( Way to go Microsoft!

Just one example: and the description isĀ "Unspecified error". Do you think that helps? aargh!

Just to get around it, I first converted from SQL 2005 to SQL 2000, and then converted to Access. The Conversion from SQL 2000 to Access ran without any problems whatsoever. It copied over all the data in less than 3 minutes. In contrast, it took SQL 2005 42 minutes to copy data over to SQL 2000. Yikes! Did I mention SQL 2005 conversion is slow also?

Posted on Thursday, March 27, 2008 4:26 PM SQL Server 2000 , SQL Server 2005 | Back to top

Comments on this post: SQL 2005 Conversion Utility

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © razisyed | Powered by: