[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

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.
0
BemboX
Asked:
BemboX
  • 2
  • 2
  • 2
  • +3
1 Solution
 
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
 
Paul JacksonCommented:
Why not detach the database and copy the files over ?

http://msdn.microsoft.com/en-us/library/ms191491.aspx
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
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
 
Éric MoreauSenior .Net ConsultantCommented:
check SQL Compare and SQL Data Compare from http://www.red-gate.com/
0
 
Paul JacksonCommented:
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

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 2
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now