473,386 Members | 1,720 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Which is better for making a copy of a database, restore or DTS?

Hello everyone!

I'd like to know which method is better for making a copy of an
existing database in SQL Server 2000, restoring from a backup of the
original, or using DTS to copy the objects to the new database. Any
caveats or drawbacks to either method? I'm just trying to lay the
groundwork for internal policies for managing our databases, and I just
want to make sure we use the best method.

Thanks!

Jul 23 '05 #1
2 1256
If you need to copy an entire database then I think you'll find Backup /
Restore faster and easier to setup and maintain. If you just need to copy a
subset of data then use DTS.

--
David Portas
SQL Server MVP
--
Jul 23 '05 #2
Another thing you might want to consider is If you have identity
columns (linking foreign keys etc) , then it is better to use Restore

Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Glen A Stromquist | last post by:
I have a 6.5 db that I want to create a copy of, I can move it to either a machine running 7 or 2000. I am more used to doing this in Oracle so pls bear with me... I don't want to have any...
2
by: Jim Andersen | last post by:
I want to take a copy of a database, and mail it to another sql-server, and then get it up and running. I normally detach it, and copy the .MDF. But there are users using the database, so that...
5
by: Kevin | last post by:
Can anyone recommend the easiest way to get a full copy of a database from one server to another. The servers are not part of the same organization or network. I have received a backup of the...
2
by: Fabius | last post by:
Hello all. I need transfer a db2 database ( tables, records ecc. ) from a server1 to server2. The operating system of server1 and server2 is win2000 server. I have installed db2 to server2. Now...
4
by: Knokmans | last post by:
Hi, All of this is still a test envinonment, but has to go on production.... I restore a database a database the follwing way db2 restore db <database> from <directory. taken at <timestamp>...
1
by: Rachel McConnell | last post by:
Hi, I am trying to import data using COPY, from a file containing thirty or so COPY commands each with 0 or more rows of data. Reason, I have a small data set I want to include into a database...
5
by: kebuchan | last post by:
Hi all, I know this is possible in Oracle but has anyone done it in DB2 and could you maybe direct me to some documentation or let me know how I would go about doing it? In the oracle world...
2
by: Mark | last post by:
Hello, if you got a tape file how can you restore the contained database onto a newly installed server? I choose Restore Database From Device then I choose DB and select same DB in combobox "To...
5
by: Steve | last post by:
Hi; I thought I would rephrase a question I asked in another post to more quickly get to the heart of the matter. My apologies for anyone who is offended by what appears to be a repetition. ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.