| Subject | Using FB/IB with Microsoft Sync Framework |
|---|---|
| Author | samcarleton |
| Post date | 2011-09-20T21:19:02Z |
I am working on a IB 7.5.1 project right now that uses a dialect 1 DB. It needs to be a player in a sync process with Microsoft Sync Framework (MSF). It all looks straight forward except for the need of a 64-bit int.
MSF calls for a 'timestamp' which turns out to be a DB wide 64-bit unique number. It is NOT a date or a time, simply a value that is unique to the DB and is 64-bit wide. In SQL Server, one can get the last one of these by selecting the @@DBTS.
The question is: How do I create effectively a 64-bit Generator? I know it won't be anywhere near as fast, what is important is working with what MSF is expecting to find, a bigint.
My current thought is to simply use a NUMERIC(18,1) in a special table and simply keep adding to it. Will that work? Has anyone ever gotten MSF to work and can share with me how?
Sam
MSF calls for a 'timestamp' which turns out to be a DB wide 64-bit unique number. It is NOT a date or a time, simply a value that is unique to the DB and is 64-bit wide. In SQL Server, one can get the last one of these by selecting the @@DBTS.
The question is: How do I create effectively a 64-bit Generator? I know it won't be anywhere near as fast, what is important is working with what MSF is expecting to find, a bigint.
My current thought is to simply use a NUMERIC(18,1) in a special table and simply keep adding to it. Will that work? Has anyone ever gotten MSF to work and can share with me how?
Sam