Replication Training

We are a software development company that is beginning to incorporate
replication into two major projects. We would like to have someone help
us with replication consulting/training/troubleshooting help.
Does anyone know someone who can and would do this? Hillary? Paul?
Others?
Paul Barbin
DBA
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
If you are interested in someone in the States contact me offline. Paul is
in Europe, although he may be willing to travel.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"PBarbin" <pbarbin@.nospam.com> wrote in message
news:O2ZXEaaxEHA.2620@.TK2MSFTNGP10.phx.gbl...
> We are a software development company that is beginning to incorporate
> replication into two major projects. We would like to have someone help
> us with replication consulting/training/troubleshooting help.
> Does anyone know someone who can and would do this? Hillary? Paul?
> Others?
> Paul Barbin
> DBA
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Hey Hillary, I see your book came out TODAY! Great. I'll be ordering
it shortly!! I thought the project had stalled (for good).
I noticed that he'd have to hop across the pond to consult here. I was
hoping you'd reply. Sounds stupid, but I'm not sure how to contact you.
Please contact me at:
pbarbin@.ledontspamwis.com
(remove 'dontspam' from the address)
Thanks.
Paul
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Replication scripts

Hi,

The company I work for delivers their developed software together with two W2K3 servers using SQL Server 2000. These two servers has two roles, production and backup, and if the production server is offline or if anything happens to it, the backup server becomes the production server. When the original production server is back online, it becomes the backup server.

I have struggled with replication on these two machines. What we would like is to have scripts for these servers. These scripts should be general so that they could be run at both servers. The current production server is setup as distributor and publisher, and the backup server is setup with a pull subscription. Also, when the subscriber is seetup, it should update its database from the publisher

Does anyone have general scripts like this?

Best,
/M

Sorry, it's not clear to me exactly what the problem is. Did you try setting up replication using the wizards? Once it's set up, you can script out the replication scenario in Enterprise Manager.|||

Is replication a part of the solution, or something you need to setup?

Would setting up Database Mirroring between these 2 servers be an option? If do then please refer to http://msdn2.microsoft.com/en-us/library/ms177412.aspx.

This posting is provided AS IS with no warranties, and confers no rights.

Replication Problem

I am making a software taking mysql as db and vb.net as front end.this software will be used in different locations.The architecture will be like all the branches will be having local mysql server and there will be a server on net which will be on MS Sql server.
all the branches will require to share some data and in some places all the data may be required coz the director of the company may wanna see the whole data.
so i am planning to use sql data relication.but i don't know what are the things i need to have on server on net ,and how to configure the whole architechture .

if anyone of you can help me plz do that i am new to Replication i can give more information about my requrements and stuff i needed.

actually i am making the ms sql server as publisher and distributor and rest of the node mysql server as subscribers.i am using mysql DSN to make the subscriber but while i run the snapshot Relication the distribution agent give an error "Invalid Cursor State"
i don't know what to do

do you sujest some way other than replication in my scenario
i am waiting for some sujetions plz help me

Thanx i advace,any comments will be greate help to me

Regargs
DeepakYou need to re-apply the latest snapshot file from the publisher and copy it to the subscriber.|||Thanx for reply

i have tried to create snapshot files many times but distribution agent gives the same error

can u please give me solution in detail coz i am new to sql replication
Thanx