asked on

Copy full sql server database from one server to another

I need a program to copy a full sql server database from one server to another.
It has to create tables and copy their data.
Is there any utility or source code to do that?
Backup is not a solution.

Paul MacDonald

Can you do a snapshot?

Éric Moreau

can you detach your database, copy the mdf file and attach it on the other server?

Paul Jackson

Why not detach the database and copy the files over ?

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

BemboX

ASKER

emoreau: I can't because first database is sql server and second is sql express. Any way I have no access to the server.
paulmacd: How do I do a snahpshot?

Paul MacDonald

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

ASKER CERTIFIED SOLUTION

Éric Moreau

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Paul Jackson

You will need access to the server for any of these options. At least you will need to be able to make a connection to it with SQL compare and sql data compare

Alpesh Patel

SQLAzureMW v3.6.2 Release BInary on Codeplex..

Rose Babu

Hi,

in SQL 2008 server itself you can do a task to generate scripts for your full db with data.

then try to run the generated script in another db, all the tables, data, procedures. etc will be created.

have a look on the link below will help you lot.

http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/

BemboX

ASKER

I'm trying using SQL Compare and SQL DAta Compare but it gives me some errors. I'll try to fix that.