PDA

Click to See Complete Forum and Search --> : SQL Server Replications


Ely
Oct 8th, 1999, 09:49 PM
Hi,
I'm writing a simple program that creates devices on an SQL server, and then creates 2 databases on them.
My problem is with the second part of the program, that should set up replication between these two databases in code. One is supposed to be the publisher and the other the subscriber.
I'd appreciate any code that'll demonstrate how to declare these databases for publishing and subscription, and create a sample publication for one of the tables in DB #1 (for example, users_table).

P.S.
I'm using VB6 enterprise on Win98, and connecting to an SQl Server 6.5 on a NT 4.0 server.

Thanks in advance,
Ely

JHausmann
Oct 9th, 1999, 03:05 AM
I'd be real interested in seeing it coded,too. Unfortunately, in the years I've been working with SQL server, we've only done it via the enterprise manager...