Managing transactional replication

Hi everybody,

I wish to manage the process of transactional replication between two SQL databases using a c# (or any other possible language, does not differ) written tool. More accurately, I have a database in my server, and I want to have the program to be run from any other computer and does the replication between the local pc(where the program is run) and my server. More to say is that the connection between the server and pc(s) is over the internet.

I would be so thankful if anyone would help me to solve the issue,

with regards

farshad

Hi FArshad.

Look at: http://msdn2.microsoft.com/fr-fr/library/ms146966.aspx

It provides more links to create your publication, subscription and synchronization using RMO (C#).

For Transaction replication, you cannot just use Internet to do your synchronization. You would need to have VPN established. However you dont need VPN and can just synchronization over the Internet using Merge replication. If you are interested, search for eb Synchronization on msdn.

Hope that helps.

|||

Hi Mahesh and thanks for answering,

The exact thing I'm looking for is a way to start the replication in a subscriber machine; where replication is transactional and subscriber can be any machine that has sql server 2000 installed and has my database and its schema configured. Because I will have new entries in database and subscribers must not change their own databases, and also to save time, I'm going to use transactional replication. For now, I know how to generate snapshot and then synchronize the subscriber with publisher's data, but as you know, after a while when database becomes larger, generating snapshot would take a lot of time, so I'm searching a better solution. Is there any way to do so ?

Cheers,

farshad

|||

If I understand right you are saying that you do not want the snapshot to be donloaded but start the subscriber with a database and data.

If so search for 'Initialize from Backup' in BOL.

|||

Thanks Mahesh,

I think I didn't say what I meant, of course this was a good help, but not exactly the solution to my problem. Thanks a lot again,

cheers

farshad