locked
sql database copy RRS feed

  • Question

  • User587273823 posted

    Hi Everybody,

                  I am having a database named "dd.mdf " in SQLServer 2008,

                 Now I want to copy the entire database to another sqlServer 2008 in another pc.


                 How to do it.

                 Anybody pls give me the steps for doing it

         

    Monday, July 19, 2010 4:25 AM

Answers

  • User587273823 posted

    Than You Very much Snop I got it working.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, July 20, 2010 9:35 AM

All replies

  • User1138824855 posted

    If the database name is dd.mdf You can copy that entire database using the following steps

    1. Generate script for the database and execute that in the desitnation server (in query analyzer)
    2. Use Database Publishing wizard to generated the script whcih is more handy in comparison to management studio
    3. Copy the .ldf and .mdf and restore that in the desination server
    4. Take the backup of database from your local server (.bak file) and restore that in the desitnation server.
    Monday, July 19, 2010 5:42 AM
  • User1283497924 posted

    Hi,

    There are several ways by which u can transfer data from one server to the another server..

    1.Take the backup of database and restore the data base to the other server.

    2.Generate SQL script .with this u will be able to get only data base schema not the data...

    now open the sql server on which u want to store the data. and create the DB and run the script.

    now u can import the data...

    for taking script:

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

    for import the data:

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


    Monday, July 19, 2010 5:55 AM
  • User587273823 posted

    Sorry All,

                I have a database in sql server 2008, i have to transfer that to 

                sql server 2005 for some teting purpose. Backup & Restore is not possible from 2008 

                to 2005 kindly let me know where i can get the Databas publishing wizard for 2008



    Monday, July 19, 2010 6:10 AM
  • User-595703101 posted

    Hi Kalidhas,

    Please check http://forums.asp.net/t/1304462.aspx and http://go.microsoft.com/fwlink/?LinkId=119368

     

    Monday, July 19, 2010 8:56 AM
  • User2057888090 posted
    1. Generate the SQL scripts of all schemas of all objects on the originore SQL 2008 Server.
    2. Run the SQL scripts on the new SQL 2005 server.
    3. Import the all data from the SQL 2008 to the SQL 2005.
    Monday, July 19, 2010 8:23 PM
  • User587273823 posted

    Than You Very much Snop I got it working.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, July 20, 2010 9:35 AM