Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Replication between linked server and local server

Author  Topic 

hornet
Yak Posting Veteran

96 Posts

Posted - 2007-01-19 : 03:30:40
Hi all!

I have 2 databases one of them is foxpro and is using as linked server and another one is SQL. FoxPro is work db at the same time SQL is using as archive. Dayily data from work db are copying to archive. I'm to do copying new data from foxpro only. I'm using ID column in SQL but data from SQL can be deleted so how do I write what i want (new records in foxpro only).

Thanks in advance!
   

- Advertisement -