Solved

to copy the contents on a database

Posted on 2009-04-06
4
190 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:
udayakumarlm 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:udayakumarlm
udayakumarlm earned 300 total points
ID: 24084620
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

863 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now