Data tarsfer from one table to another with different schema on sql server 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ABCL - 16 Mar 2008 14:01 GMT

Hi all
I am working on SqlServer 2000,
When row will be inserted/updated in one table that data neds to be
inserted/updated into the another DataBase on the same machine. Both
table has different schema, what is the Better solution? I know we can
do it with Trigger, But Is there any better way to do it?

Thanks

Reply to this Message

Uri Dimant - 16 Mar 2008 14:20 GMT

ABCL

> do it with Trigger, But Is there any better way to do it?

How do you insert/update the data ? By using SP? If so insert/update into
another table within the same SP.
I hope you don't have permmisions problems when you update/insert the
data into differnt schem/user owner object

> Hi all
> I am working on SqlServer 2000,
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

ABCL - 19 Mar 2008 14:31 GMT

> Hi all
> I am working on SqlServer 2000,
[quoted text clipped - 4 lines]
>
> Thanks

Actually we want to SynchroniZe the Data from one DataBase to another
and vise versa on Insert/update and delete.
How Can we Perform Data Synchronization on both the DataBase with
different schema.
If I write trigger, I think There will be endless loop If both Tables
hava trigger on inster/update and Delete.

Do u have any solution for that? I am new to perform this kind of task
Is it possible with DTS( scheduled job)?

Is there any Performance Issue?

Reply to this Message