Re: synchronization with heterogeneous tables and referential integrity

DA Morgan wrote:

> Given that SQL Server is incapable of providing a point-in-time valid
> view of the data how are you planning to manage an accounting
> application between two very different database concepts?

Perhaps my almost-zero knowledge of SS prevent me to fully understand your answer, but I was thinking about a night synchronization job. For my application is OK to "see" the accounting data the day after they are inserted into the accounting application. Can I assume that at e.g. midnight SS is capable of providing me a valid view of the data, giving that last accounting information is inserted into the system at 5:30 PM maximum?

Thank you. Kind regards,

-- 
Cris Carampa (cris119_at_operamail.com)
Studente fuori corso di Iconologia Braille
Facoltà di Irrilevanza Comparata