Replication Programming Samples

Replication Programming

Replication Programming

Replication Programming Samples

The following samples illustrate Microsoft® SQL Server™ 2000 replication application development in various environments and languages, including Transact-SQL , Microsoft Visual C++®, and Microsoft Visual Basic®. The samples and associated headers and libraries are required for successful execution of several sample applications.

To install the samples and related headers and libraries using the SQL Server Installation Wizard

  1. On the Setup Type page, select Custom.

  2. On the Select Components page, under Components, select Code Samples.

  3. In the Select Sub-Components dialog box, select Replication.

  4. On the Select Components page, under Components, select Development Tools.

  5. In the Select Sub-Components dialog box, select Headers and Libraries.

After installation is complete, if you have accepted the default installation location, the path C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\sqlrepl will be on your computer. The sqlrepl directory contains an executable file, unzip_sqlrepl.exe, which expands the samples into useable files. Double-click unzip_sqlrepl.exe, and you will be prompted to enter that path to the folder where you want the samples stored. The samples assume that the default is selected, and samples are not installed to an alternate location. The expansion adds several subdirectories to sqlrepl.

The Visual C++ samples were tested with Visual C++ version 6.0, Service Pack 3. The Visual Basic samples were tested with Visual Basic version 6.0, Service Pack 3. The samples have been run on Microsoft Windows NT® version 4.0, Service Pack 6, and on Microsoft Windows® 2000 operating systems. They have not been compiled or tested on any other hardware platform supported by any other compiler.

For Visual C++ samples to compile, header and libraries file paths must be set properly to obtain the required replication files. After installation, set your project options for include files to C:\Microsoft SQL Server\80\Tools\Devtools\Include, and set your options for the library files to C:\Microsoft SQL Server\80\Tools\Devtools\Lib.