Post reply

Trasfer Database from one SQL server to another

  • February 19, 2009 at 5:08 am

    #200104

    I want to create a database, with data, users, security, relationships etc. on SQL Server 2008

    and then I want to move the database (with users, data, security, relationships, etc) to another server.

    Is there any tool I can use it for this purpose?

  • February 19, 2009 at 9:27 am

    #946843

    Do you want to move the database to another SQL 2008 instance? If so, make a full backup and restore it on the destination instance. If the destination is SQL 2000 or SQL 2005, use SSIS.

    Greg

  • February 20, 2009 at 2:14 am

    #947360

    Thanks for your reply,

    Actually I want to copy the database from one SQL server 2008 to another Sql server 2008. 1st server is active server and second server is test server.

    Well, I'm new one in SQL server, so can you describe me procedures for the copy? (or backup or what ever?)

  • February 20, 2009 at 2:28 am

    #947369

    micsak (2/20/2009)

    Thanks for your reply,

    Actually I want to copy the database from one SQL server 2008 to another Sql server 2008. 1st server is active server and second server is test server.

    Well, I'm new one in SQL server, so can you describe me procedures for the copy? (or backup or what ever?)

    What is the size of your database? If it is small then you can backup and restore Or you can detach the database and attach it.

    Check this out:

    http://msdn.microsoft.com/en-us/library/ms191491.aspx

  • February 20, 2009 at 2:32 am

    #947371

    Thanks, I will try it

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

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