Solved

to copy the contents on a database

Posted on 2009-04-06
4
198 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

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…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
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 …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

773 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