Synchronies Database....

[Errods]

Hi,

I need to design a application which will be using a Remote Database but will also maintain a Local Copy of the database.....

How can i maintain a Local Copy..... Is there any Query which compares and Syncs 2 databases....... Or i need to copy the database from the remote system to the Local Machine.........


Thinking of using MS-SQL.

Is there any database application which will sync itself.

 

[jshultz]

You will have to write your own utility to do this, which can be kind of tricky. You can query each table getting the contents and recreate it locally, or you can use SMO to backup the database and then copy the database backup locally and restore it. I don't know any other way to do it, either way it is a little ugly.

 

[Errods]

What about Replication does this help........

 

[jshultz]

Or have a look at this thread http://www.vbdotnetforums.com/showthread.php?t=24556&highlight=replication

 

[Errods]

Thanks It helped.......