June 25, 2004 at 4:29 am
Hi
Have 2 servers. On server 1 database A should be replicated to server 2 database B.
When I create a publication from database A, it assigns automat. database A on the second server.
Anyone got any idea how can i tell SQL that it should be database B ?
Thx
J
JV
June 25, 2004 at 9:54 am
Which server is enabled as a distributor? aka. Has the distribution database on it.
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
June 28, 2004 at 12:45 am
Server A
JV
June 28, 2004 at 4:48 am
If you created the subscriber using T-SQL, then in the following query, you would specify the "SubscriberName" to be Server2 and the SubscriptionName should be specified as "DatabaseB"
EXECUTE sp_addsubscription @Publication = 'PublicationName'
, @article = 'ArticleName'
, @subscriber = 'SubscriberName'
, @destination_db = 'SubscriptionName'
, @sync_type = N'automatic'
, @update_mode = 'sync tran'
, @dts_package_location = N'distributor'
If you are setting up the subscriber using enterprise Manager, when you try to Push a new subscription, you will be prompted for the Subscribername which should be Server2 and the Subscription name which should be DatabaseB.
Hope this helps.
Regards,
Beulah Kingsly
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply