Advice for beginners - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Advice for beginners

Author

Topic

nr
SQLTeam MVY

12543 Posts

Posted - 2003-05-22 : 21:03:49

When you are doing an incremental import of a remote table and using a staging table and deleting from your main table before the insert so that you can repeat batches it is VERY important to delete using ALL fields of the primary key.

Especially if you have spent all week getting 50 million rows across.

.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

byrmol
Shed Building SQL Farmer

1591 Posts

Posted - 2003-05-22 : 21:26:54

Also...

When you are reorganising your database (BCP OUT Then BCP IN), ensure that the BCP OUT worked before dropping the database. :-)

DavidM

"SQL-3 is an abomination.."

chadmat
The Chadinator

1974 Posts

Posted - 2003-05-23 : 12:35:05

quote:

Also...

When you are reorganising your database (BCP OUT Then BCP IN), ensure that the BCP OUT worked before dropping the database. :-)

DavidM

"SQL-3 is an abomination.."

Or better yet, ALWAYS have a recent backup.

-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources