Hi Everyone
I have a huge problem after I noticed that SQL Server Agent has been removed
and need your advice about how to program replication between SQL Server Express and SQL Server 2005
So far I have encountered the following problems
SNAPSHOT
1. When I created my snapshot Irealized it wasnt running. I then read from the documentation that i had to resort to the Windows Synchronization Manager as there was no SQL Server AGENT within SQL Server Express to accomplish this function
I did this and it worked but wouldlike to control this programmatically as well
REPLICATION
2. Now I have a standalone SQL Server Express which is a subsciber to the SQL Server 2005 Database
How can I force the merge replication programmatically ie Vb.NET
Your kind advice is appreciated
Regards
Touraj
To learn how to use replication with SQL Express, see topic "Replicating Data to SQL Express" in Books Online.
|||Thankyou very much
No comments:
Post a Comment