Solved

to copy the contents on a database

Posted on 2009-04-06
4
208 Views
Last Modified: 2012-05-06
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
Comment
Question by:teodor76
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
udaya kumar laligondla earned 300 total points
ID: 24084367
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
 
LVL 7

Assisted Solution

by:Chandan_Gowda
Chandan_Gowda earned 200 total points
ID: 24084369
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
 

Author Comment

by:teodor76
ID: 24084535
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
 
LVL 12

Assisted Solution

by:udaya kumar laligondla
udaya kumar laligondla earned 300 total points
ID: 24084620
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question