• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

to copy the contents on a database

a customer want to me to copy the content(tables and queries)of the database server1\ X database into the databases server2 \ Y database and server2 \ Z database..how can I copy the contents of the database into another databases on the otherservers?
0
teodor76
Asked:
teodor76
  • 2
3 Solutions
 
udaya kumar laligondlaTechnical LeadCommented:
if you are looking at full copy of the database use the SQL SMS and Copy the database to the destination servers
if you are looking at copying tables you can use database publishing wizard by microsoft and create the script and execute the same on the destination datbases.
use database publishing wizard on X and crteate the script for tables run the script on Y,Z
0
 
Chandan_GowdaCommented:
you can use export/Import Wizard present in sql server 2005
Please follow the below link
http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm
0
 
teodor76Author Commented:
Can I copy only tables and queries in a database with import/export wizard? or where can I find database publishing wizard and how can I create a script to copy tables and queries?
0
 
udaya kumar laligondlaTechnical LeadCommented:
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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