Data Migration

  • Does anyone have a checklist or any document/link that details on what all issues they had when migrating data from sql 7 to sql 2005. This would also include any sql code where *= needs to be converted to 'left outer join' and so on. Any help on this will be greatly appreciated.

    TIA

  • Not worked with migrating 7 to 2005. But this blog article did help me lot from 2000 to 2005. I think the issue would be more or less same. Worth looking at this.

    http://decav.com/blogs/andre/archive/2006/04/11/10.aspx

    But, apart, how about migrating to 2000 and then again migrating cleanly to 2005 as per instructions from microsoft - Just a thought. You will find 100's of articles on migrating from 2000 - 2005.

    SQL DBA.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply