Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    Sheffield, UK
    Posts
    17

    Cool Unanswered: Transfering database

    Hi all,

    Really easy question I think. I've been working on a website using a back end SQL database. All the tables, views etc have been designed and built. There is some data in the tables. Now that I have developed it I want to move the whole database onto the live Server which resides on another machine. How can i transfer a database from my development server to the live one?

    Thanks

    Wheelz

  2. #2
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    detach the database from test server and attach it to the live server.

    see sp_attach_db, sp_detach_db BOOKS ONLINE.

  3. #3
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    u can also use transfer database wizard to copy database objects, users etc. Rather more easy.

  4. #4
    Join Date
    Dec 2003
    Location
    Sheffield, UK
    Posts
    17

    Cool

    Thanks Talat. I'll try the wizard approach.

Posting Permissions

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