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.
| Author |
Topic |
|
antony_cts
Starting Member
1 Post |
 Posted - 2009-12-17 : 21:54:43
|
| Dear All,I got a project to synchronize tables between MS SQL 2005 with PostgreSQL. I haven't learn Replication and the assignment is using Foxpro 9.0 to write a synchronization. At first, I think I could submit each statement to SQL server like:SET TRANSACTION ISOLATION LEVEL SERIALIZABLEbegin transactionselect....But what if the connection got a problem in the middle. I remember SET TRNASACTION ISOLATION ... will keep the lock even the connection is lost in SQL 7. I think it still the same in SQL 2005. Is there any method to do such locking? Any suggestion is welcome.Thank you very much!Best Regards,Antony |
|
|
|
|
|
Is there any client side locking?