Hi All,
I have one database in India, I want to replicate its data here, and there is no logic to guess in which table data is changed so I have to replicate all tables.
I cannot do Snapshot because there is no good bandwidth between the servers.
My concern is if I will go for transactional replication. Do I need to change some table layout there? As I remember when I did replication in SQL Server 7.0 I added two fields in each table one for timestamp and one for binary.

Any suggestion for how can I replicate the data? Now The database is in SQL 2000

Thanks
...ashish