Post reply

data sql server 2000 to sql server 1202

  • April 6, 2014 at 8:34 pm

    #290015

    I have a windows server 2000 and SQL Server 2000. how to move the data from sql 2000 to sql 2012. Please provide a way for this problem. thanks for the help

    regards

    oderudin

  • April 6, 2014 at 9:45 pm

    #1703628

    Please provide more information on what you want/need to do...

    Are you just moving the data from one database into another one?

    Are you wanting to upgrade the server and SQL Server instance to 2012?

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • April 7, 2014 at 3:58 am

    #1703695

    (Sorry; I keep generating duplicate posts.)

  • April 7, 2014 at 3:58 am

    #1703694

    Well, a backup and restore is probably simplest. You can't restore a 2000 backup straight to 2012, so do you have a 2005/2008/2008 R2 instance you can restore to first?

  • April 7, 2014 at 11:08 am

    #1703889

    Depending on how complex or simple your tables are..... You might be able to simply script out the tables and then use the import/export GUI to move the data.

Viewing 5 posts - 1 through 4 (of 4 total)

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