sql database copy

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

     

Answer 1

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.

Answer 2

User2005055533 posted

Check it..

http://technet.microsoft.com/en-us/library/ms165673.aspx

http://stackoverflow.com/questions/773059/how-to-recover-database-from-mdf-in-sql-server-2005 

Answer 3

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

Answer 4

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

Answer 5

User-595703101 posted

Hi Kalidhas,

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

 

Answer 6

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.

Answer 7

User587273823 posted

Than You Very much Snop I got it working.