Solved

to copy the contents on a database

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

708 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

15 Experts available now in Live!

Get 1:1 Help Now