MS SQL SERVER: reconcile, deployment

Mar 15 2008 9:51 AM

Hello,

Please how can I deploy an SQL Server database that is required by my program to a Local(intranet) SQL Server and also to a Remote SQL Server.

How can I also reconcile a local DB with a Remote DB( they are the same but when connection is lost with the remote DB, the program uses the Local DB) so I want the Remote DB to be the same with the Local DB when connection is restored)

If anyone can recommend a book or help with this problem, I would be most grateful.

Alex Crying