Question about using DTS-Export/Import

[appi]

Hi all,

just another question about "How to..."
I have two SQL Server2000 on different Windows-Boxes and need to get the Data replicated or copied automaticly.
I just tried to use Replication, but the replication will set all Tables in the destination db as user dbo. The Tables has a named user and we neeed to have them owned by this user after copying in cause of the Toll using this DB.

If I try to use DTS-Export it shows the same behaviour in the summary. The Tables in Source owned by xxxx but in destination by dbo.

If I use Export and Import by hand, the problem will be that export or import could only handle local drives and not mapped drives which I need to get them over to the second box.

Any clean way to work this out ?

regards´
appi

 

[cyno]

I think you will have an option to specify the destination table name and also the owner name under article properties.

Cyno

 

[appi]

I just found a way, but I do not use DTS now.
I am working now with job scheduling and manual backup job with UNC-directory