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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 SQL table and XML File

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-03-13 : 07:47:32
Davide writes "Hello,
I need a very big help.

I have one local DB to syncronize a Remote DB.

I have generate an XML file and I want import the file in the DB but the DB is very big and I don't want truncate all table and ricreate because the users must use a 56Kb line for download the syncronization file (so the file must be the small as possible).

The question is:
How I can know witch data modification are made in the MASTER db from one date to another date? (I can use the transaction log?)


Thank you very mutch (and excuse me for my english).

Davide"
   

- Advertisement -