DTS Copy Package loses tables keys and defaults

[JohnBates]

Hello -

I use this DTS package to refresh the database on my Test server.

The package - Drops tables in the destination db
- Creates tables in the destination db
- copies data from source --> destination

The data gets copied... no problem there.
Problem: The Keys and Default values do not get copied to the Destination tables

(I drop and recreate the tables to be certain that any new tables in my production db get restored to the test db)

What can I do to keep from losing the keys and defaults??

Thanks, John

 

[tlbroadbent]

Have you reviewd the 'Copy All Objects' and 'Use Default Options' to determine if all objects, including defaults, are selected and that "Advanced Copy Options" include keys? Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost

 

[foxdev]

I'm sure Terry's nailed it (because I've goofed this myself so many times). One tip - you might want to tell it not to copy logins, as this can sometimes cause problems if the two machines are on different networks. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com