November 27, 2008 at 5:40 am
Hi Team
This is my second post to SQL Server Central. My first post was very helpful and i did get replies for all questions that was asked. Thanks for the support guys.
I have just started to work with SQL and finding out new things everyday which helps me to do my job.
The next task which has come is doing a replication. I would like to do a unidirectional replication where in data flows only in one direction but i would like to do this on a scheduled basis.
I have 2 servers one which will act as the Publisher and Distributor and the second one will act as the Subscriber.
I have setup the Distributor and was following the steps to do the Publishing. It came as far as selecting the tables(articles) which needed to be published.This database that i am using does not have any primary keys for any of the tables. So i am stuck at that bit. ( i have used transactional replication).
I would need some guide in selecting the replication technique and also the process.
Thanks
Thomas
November 27, 2008 at 6:01 am
If you have no primary keys (aside, why not?) then you cannot do transactional replication. You can use snapshot, which will copy the entire database over at scheduled intervals, but that's the only option with no primary keys.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply