database synchronization

Hello,

I need to synchronise two database, with the same structure but with other data.

These database are stored in different companies. So, at the end of the day, all data has to been copied from company Y to company X. After copying the data from Y to X, company Y has to retrieve the full database from X.

Can someone give me any directions to start with the application?


Thanks.

If you're using SQL Server, look into replication. Do a search on Bi directional replication - it will probably be more useful than the plan you have in mind.