Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224

    Unanswered: Migrating database

    Can anyone tell me how I can migrate database from one server to another
    I need to migrate all the tables, stored procedures, functions and so on

    thank you

  2. #2
    Join Date
    Jul 2005
    Location
    New Zealand
    Posts
    61
    You can use the Copy Database Wizard to achieve this. See BOL for more info.

    As you are moving the database to a new server, you will have to manually delete the data and log files on the old server once the copy process has completed.

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by fullymooned
    Can anyone tell me how I can migrate database from one server to another
    I need to migrate all the tables, stored procedures, functions and so on

    thank you
    As noted earlier, you can use the Copy Database Objects wizard. Or:

    1. You can load a backup of your database onto the new database (you will have to manually add in SQL Logins and resynch those logins with the users in the new database).

    2. You can detach the old database, copy over the .mdf and .ldf files and then attach it to a new server (again, you will have to manually handle SQL Logins and synch them to the new db).

    Regards,

    hmscott
    Have you hugged your backup today?

  4. #4
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224
    I dont want to detach the old database. That needs to stay the way it is. Can I just copy over all the tables, sp, views and fns along with the logins. Would it work that way. I know its going to be a lot of work but it seems like the simplest way to go without making changes to the old database

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •