Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-09 : 08:28:33
|
| yiotis writes "Is there a way where you can programmatically (via visual basic) replicate two or more SQL Express databases located on multiple computers without the need of SQL Server 2005 acting as a publisher. From what i understand this is a limitation in SQL Express.Right now i have SQL Express installed on 2 machines. I am able via vb to communicate with each database, read and write data between databases but cannot seem to figure out how to perform a simple replication.Bottom line is, i need to be able to replicate via vb code 2 sql express databases with each other.Thanks" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-09 : 22:36:39
|
| then you will need to simulate how replication works using vbi don't think this will be realtime unless you employ triggers to call the vb exe to propagate the changes--------------------keeping it simple... |
 |
|
|
|
|
|
SQL Express 2005 Replication via Visual Basic