May 8, 2009 at 5:55 pm
Hi All,
I'm currently involved in a project to migrate our production databases from SQL Server 2000 to 2008.
I have a number of SQL server 2008 machines set up (One which will be the replication pulisher) and need to copy the data from a current production server to the new server. So far I've received the suggestions of using the data import/export wizard, BCP, or using the ADO.NET 2.0 SqlBulkCopy functionality.
I've found a lot of helpful advice on these boards and was wondering if someone with experience doing something similar could provide any insight.
Thanks,
Jeff
May 9, 2009 at 9:27 am
If your application is transaction intensive you may have to rewrite your data access because it will improve your application by almost 50% because 2008 Microsoft implemented ANSI SQL 2003 overloaded transaction. That is you can pass in more than one at the point of connection. If it is not transaction intensive you may still need to do minor changes. One more thing you may have to rewrite most JOIN operations beause the current JOIN syntax the where clause is just a filter as the and operator so most of your 2000 JOIN code will blow.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply