Hi,
I need to replicate data from tableA, databaseA to tableB, databaseB. The table structure of both tables may not same. I need to do some custom transformation before move it from table A and B. Also, I need the records in table A to be inserted to tableB if not already existed and update it if it is existed.
Can I use SQL Server Replication or DTS to achieve this?
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...