Replication

[faisalkm]

Hi guys,

I'm sure u can do this. I have created a wizard for doing replication with SQL Server. I use SQL DMO to program this Wizard. The problem I face now is How would I know whether a Server is enabled for replication or how can i enable a server for replication. Please help ..it's very very important

Faisal

[davidrobin]

This isn't really my area of knowledge as far as SQL server goes more my area of interest (I am more SQL language and VB). I do have some questions that may help others to respond.

What version of SQL server are you using?
I take it the SQL DMO is a feature of SQL server?
Are you replicating the SQL database to a different hardware server or the SQL Server installation on the same hardware server under a different name?

As you say I'm sure someone knows or can help you find out.

[faisalkm]

Hey

I'm using SQl Server 7.0. SQl DMO is an object model for programming SQl Server model from any windows development tool thgat supports COM. I need to replicate to different hardware server and that does'nt metter. I was able to list all available sql servers on the network and managed to create Replication by manually enabing the server for replication through the enterprise manager of SQl Server.But the problem is that I can't do it by code. Please anybody help..The deadline is looking at me...

[davidrobin]

This link is the best I can do as SQLDMO is not my thing.

http://msdn.microsoft.com/library/psdk/sql/replsamp.htm

if you read the discriptions I am sure you will find one of the examples a help.

This is the best I can do unfortunately.

[faisalkm]

Thanks for the link davidrobin. But i can't download the samples from there?

[davidrobin]

email me and i will send you the sample zip file which should help

[faisalkm]

I got it!!!!!!!!!...Thanks for your support and partcipation!!


Faisal