tables export 'Success' but no relationships...

[DLu]

I export all tables from serverA databaseAA to serverB (both SQL2k sp3)databaseAA with 'Success', but without any relationships. In SQL6.5 Tools of Transfer will bring all objects include relationship.

I also tried export "All Objects" which fails with unclear message. I just don't want to do a backup and restore....

thanks
David

[rmiao]

Never had this kind of problem when transfer all db objects. What's the error in dts log file?

[skhanal]

Did you use default options (which copies primary and foreign keys).

If foreign keys are not getting transferred you can generate table schema script and grab foreign keys script from there and recreate them in target server.

[DLu]

I did use 'default option' which copies all pk, fk, indexes and triggers...

at the time of almost 99% was done, error: [SQL-DMO] upexpected parameter value or other condition.
not quite sure where is the dts log file?

I have the script to generate relationship constraints but I want to know why the copy objects failed at the ending.

thanks
-D

[rmiao]

You can double click the error message or look at dts log file to get detailed info about the error.

[DLu]

After set up the DTS error log, here is the errors(it does not help much):
(it is a simple Copy SQL Objects Task)

Step Error Source: Microsoft SQL-DMO
Step Error Description:[SQL-DMO]Unexpected parameter value or other condition.
Step Error code: 80045339
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:1132

[rmiao]

Where did you run the dts? From one of the server or your client pc?

[DLu]

I run the DTS from the Copy Source Server.

[rmiao]

Try it from target server. May need reinstall mdac on source server.

[DLu]

I had upgraded my copy source SQL2k from SP2 to SP3 with MDAC reinstalled and checked copy Target server is sp3 already.
Attached is the detail error .txt.

I will try to copy from Target...
thanks
David