Hello NG,

i really like the DTS, but why one earth cant the
DTS copy the primary key property?

I always have to edit the importetd tables manually and set
the primary key propertie on the correct column.
Why does this information get lost?

It cant be so hard to check if a column has the primary key property and
than create the column in the target with the primary key property.

Is their any hidden way to do this automaticly without editing the skript?

Regards

Michael Brockhoff

What are you using to take across the data?

If it is the DataPump task this behaviour is correct as ALL it does is
move data
You could use the Transfer Objets task to do this and you can select to
move Keys, indexes etc etc.

Allan

"Michael Brockhoff" <spammichzu (AT) aol (DOT) com> wrote

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag news:OBxcatqGFHA.3648 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

At the Moment i alway use the wizard to move one Table to another DB.
Wherer would i find the "Transfer Objects task"?

Regards

Michael

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag news:OBxcatqGFHA.3648 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Ok I found it. But is their a way to copy only certain Tables?
I did not found any selection wich Tables i want to move frrm one db to another.

At the moment i could only move all Tables from one db to another db

Regards

Michael

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag news:OBxcatqGFHA.3648 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

Ok me again

Well i just have to uncheck copy all objects than i can copy
certain tables