May 23, 2002 at 11:44 pm
pls help if any body know.
Is it posible to write sql script to replicate data from one server to another. Requirement is like that as soon as any data changes in one server it should replicate the change data in other server.
tiwary
May 24, 2002 at 12:48 am
SQL server can handle all this...see below...
Replication Architecture
Replication is a set of technologies that allows you to keep copies of the same data on multiple sites, sometimes covering hundreds of sites.
Replication uses a publish-subscribe model for distributing data:
A Publisher is a server that is the source of data to be replicated. The Publisher defines an article for each table or other database object to be used as a replication source. One or more related articles from the same database are organized into a publication. Publications are convenient ways to group related data and objects that you want to replicate together.
A Subscriber is a server that receives the data replicated by the publisher. The Subscriber defines a subscription to a particular publication. The subscription specifies when the Subscriber receives the publication from the Publisher, and maps the articles to tables and other database objects in the Subscriber.
A Distributor is a server that performs various tasks when moving articles from Publishers to Subscribers. The actual tasks performed depend on the type of replication performed.
Microsoft® SQL Server™ 2000 also supports replication to and from heterogeneous data sources. OLE DB or ODBC data sources can subscribe to SQL Server publications. SQL Server can also receive data replicated from a number of data sources, including Microsoft Exchange, Microsoft Access, Oracle, and DB2.
May 24, 2002 at 3:59 am
thanks for ur reply
But can we make sql script for replication.
tiwary
May 24, 2002 at 4:51 am
The easiest way to do so is to set it up via the wizards/Enterprise Manager the first time, it has an option to let you script out the entire replication setup.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply