Post reply

Data Migration from SQL Server 2000 to SQL Server 2005

  • October 22, 2007 at 3:36 am

    #179516

    Hi,

    I have a requirement where in, I have to migrate the data from SQL Server 2000 to SQL Server 2005, but the main challenge here is that the two database table structures are different. I would like to know which approach would be most the appropriate? also any article links which would help me achieving this.

    Thanks in Advance,

    Prashobh

  • October 22, 2007 at 3:42 am

    #744046

    You could export the data using bcp, then import it? But there are excellent third party tools that can help you here. They can map columns in such data movements. One is SQL Data Compare for Red Gate.

    Disclaimer: I work for Red Gate.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • October 27, 2007 at 9:52 am

    #746000

    Refer the below link to upgrade SQL 200 to SQL2005

    http://www.sqlservercentral.com/articles/Administration/2987/[/url]

    Regards..Vidhya Sagar
    SQL-Articles

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

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