Đang chuẩn bị liên kết để tải về tài liệu:
MASTERING SQL SERVER 2000- P21

Tham khảo tài liệu 'mastering sql server 2000- p21', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 1020 CHAPTER 27 REPLICATION company with different data-processing rules. In this instance select No and click Next. 10. The next screen asks whether there are any subscribers that are not running SQL Server 2000. This is because other database systems may not understand properties that are proprietary to SQL Server 2000. Also the snapshot can be stored in a format that only SQL Servers will understand a binary format which will make replication faster. If there are third-party servers involved the snapshot must be stored in a format that they can read character mode . Accept the defaults here and click Next. 11. On the next screen you need to choose what you will publish as an article. Under Object Type leave the default of Tables checked this just limits the display to tables only . Then on the right side of the dialog box check the box next to Employees to enable it for publication. 12. Click the ellipsis button next to the Employees table to bring up the properties for the article as tables are called in replication . 13. On the General tab of the Table Article Properties dialog box change the Destination Table Name to Repl_Employees and click OK. CREATING AND SUBSCRIBING TO A SNAPSHOT PUBLICATION 1021 14. Click OK to continue to the next screen where you are warned about the identity replication issue and click Next. 15. On the next screen you are asked to select a publication name and description. In the Publication Name box enter Northwind Employees and leave the description that is typed in for you. Click Next. PART VI Advanced Topics 1022 CHAPTER 27 REPLICATION 16. You are now asked whether you would like to customize the publication further by allowing anonymous subscribers or adding partitioning. Select Yes and click Next. 17. On the next screen you are asked whether you would like to vertically or horizontally partition the data in some of the articles. Leave both boxes unchecked and click Next. 18. You are now asked whether you would like to allow .