Keeping databases the same

[witzulu]

Hi

I have 2 databases on different locations. and need to ensure that they are syncronised daily.

I have never used webservices and was wondering if this could be used?.

If so could you suggest some good tutorials please

Thank you

 

[Administrator]

What type of database, i.e. Microsoft SQL Server?

 

[TechGnome]

And are we talking about just the data, or the table structure as well (Tables, stored procs, views, etc)

Tg

 

[Administrator]

You are asking about keeping two databases synchronized. What is your data storage medium? Access, SQL Server, Oracle, MySQL, VistaDB, Firebird, DataSet, what?

 

[witzulu]

The databases will be Microsoft SQL and I only need to keep the data syncronised the structure will not be changed.

 

[Administrator]

You may want to research DTS or use the features of SQL Server itself to schedule synchronizations, secondly replication as an option as well.

 

[witzulu]

Thank you