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.
BemboXAsked:
Who is Participating?
 
Éric MoreauSenior .Net ConsultantCommented:
check SQL Compare and SQL Data Compare from http://www.red-gate.com/
0
 
Paul MacDonaldDirector, Information SystemsCommented:
Can you do a snapshot?
0
 
Éric MoreauSenior .Net ConsultantCommented:
can you detach your database, copy the mdf file and attach it on the other server?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Paul JacksonSoftware EngineerCommented:
Why not detach the database and copy the files over ?

http://msdn.microsoft.com/en-us/library/ms191491.aspx
0
 
BemboXAuthor Commented:
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?
0
 
Paul MacDonaldDirector, Information SystemsCommented:
0
 
Paul JacksonSoftware EngineerCommented:
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
0
 
Alpesh PatelAssistant ConsultantCommented:
SQLAzureMW v3.6.2 Release BInary on Codeplex..
0
 
Rose BabuSenior Team ManagerCommented:
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/

0
 
BemboXAuthor Commented:
I'm trying using SQL Compare and SQL DAta Compare but it gives me some errors. I'll try to fix that.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.