Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS transfer

Status
Not open for further replies.
gc6294

gc6294

IS-IT--Management
Feb 23, 2004
56
US
When I use DTS to copy a table from 1 database to another, where the table already exists in the database I am copying to, will it overwrite the existing table or will it append the data to what's already there? Thanks..
 
Sort by date Sort by votes
If you click on the destination table in the DTS wizard it will give you the option to overwrite the data, append or drop and recreate the table. By default it will append.

- Paul
- If at first you don't succeed, find out if the loser gets anything.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

awaria
  • Locked
  • Question
Automate nightly database data transfer between SQL environments on different servers
Replies
3
Views
72
fredericofonseca
fredericofonseca
Amesville
  • Locked
  • Question
Transfer a SQL Server 2008r2 DB to another computer?
Replies
1
Views
19
SQLScholar
SQLScholar
ahm1985
  • Locked
  • Question
Transfere data from branch to branch backup small size
Replies
4
Views
69
SQLBill
SQLBill
taualpha68
  • Locked
  • Question
SQL Transfer Provider Error
Replies
1
Views
39
gmmastros
gmmastros
lifesupport
  • Locked
  • Question
DTS install
Replies
1
Views
48
JayKusch
JayKusch

Part and Inventory Search

Sponsor

Back
Top