You are here: Synchronize data between 2 instances of SQL Server Express? « MsSQL Server « IT news, forums, messages
Synchronize data between 2 instances of SQL Server Express?

Posted by holysmokes99 on 10/01/67 11:40

I am building an application with a SQL Server 2005 Express backend. I
would like to create a secondary instance the database on another
server that will serve as a fail-over in case the primary server goes
down (there is only the Express version of SQL Server in this picture).

I see that replication in SQL Server Express only works as a
subscriber and not a publisher. Can anyone suggest a method that I can
ensure that both instances of the database propagate data between them
when they are both available? The app is written in VB.Net.

Thx,
Marcus

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация