Overview

SQL Server 2005 Replication Defining Replication Databases

• Register and connect the client SQL Server (Subscriber) on to the Publisher SQL Server

• Create the New Data base on to the publisher machine (Database name: Publisher).
  If the database is already exist then ignore the creating new database.

• Create the New Data base on to the Subscriber machine (Database name: Subscriber).

• Importing tables from Ms-Access in to the publisher database, to do that we need to download cBizOneHosting.mbd file from the following link.

  Link: http://www.cbizoneindia.com/downloads/cbizoneindia.rar

  Now, import all tables in 'cBizOneHosting.mdb' in to the publisher database and Run the downloaded Script file in SQL Query Analyzer.

  If the data already exists in the database then we can proceed with that data.

Proceed with further Screens…

 

• Open the Publisher database with connecting through the cBiz.

• Add few records in the cBiz to have the replication with Subscriber.