Replication by programming?
-
Hi
Newbie to this area. All PRO, please help!
I am working on a project where I could "replicate" or "mirror" the entire database on the same or another server. I understand that the EM replication is very feature rich and GUI driven - which many of them are rather too much for what I wish to achieve. In fact, I am not even sure if I should be using replication at all.
Anyway, the idea is to programatically capture the entire database and mirror it onto a new database. The process from start to finish has to be driven entirely by script. Has anyone done something like this before? It sounds simple but I just cannot get my head round.
Appreciate your comments please. Many thanks to all.
Herb
-
Hi,
If you want to use replication , you have to set it up on the SQL server anyway, you can also make the SQL server automatically publish as well as subsribers automatically pulling, using the agents. Most of which can be scripted through EM once, and then used elsewhere (I think its primarily for the subscribers)
If you are talking truly programmatically, Then there are Visual Basic.Net classes / etc that you can use..AFAIK though you have to setup the replication on the server first to use it.. Do a search on this site, for replication basics, as it was just covered in a number of articles about 1-2 months ago, on this very site...HTH
I prefer merge replication to keep everything up to date (two way updating)Have fun
------------------------------
Life is far too important to be taken seriously
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply