Replication 1

[cdassouk]

I want to enable a SQL server 7.0 for replication from within Visual Basic 6.0.

How can I do it?

Thanks

 

[TomSark]

I'm trying to figure out what you mean by 'enable', but...

There are two COM objects available to you to control replication (initialize and synchronize). Read about the SQLMerge (Merge Replication) object and the SQLDist (Snapshot and Transactional Replication) Object in books online.

If you are simply trying to enable a server for replication, you could script this in a stored procedure and call it from VB. You should also be able to use the SQLDMO object to do this...

Tom

 

[cdassouk]

There is one stored procedure in MS SQL7 to add a distributor which is : sp_adddistributor.

I need to know if it is possible to add a distributor by using SQL-DMO from Visual Basic rather than calling this stored procedure.

Thanks