Post reply

Transferring from 2000 to 2005 for reporting

  • January 28, 2008 at 8:28 am

    #178576

    I am new to SQL Server. I have been asked to transfer a source SQL 2000 database with procedures to another server running 2005 several times a day. This data is to be used for reporting and analysis purposes, the transfer being from OLTP data.

    I have been using the Copy Database wizard in 2005 and even though I can see all the copying taking place without errors when I look in the destination database it is empy. I assumed the table definitions are automatically transferred too.

    Any help here would be appreciated.

  • January 28, 2008 at 9:42 am

    #772520

    Well, there are much better ways to do what you're trying to do. Why don't you just copy the data from the tables over instead? You can try to find some way to only capture the changes to keep your time down.

    Barring that... if I had to do a complete restore like that all the time, I'd rather do a backup on the source side, and restore it on the other side. It's probably quicker than copying objects and data across, and it's definitely more stable.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

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

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