Opening the "create and manage publications"

Assignment Help Computer Engineering

Reference no: EM1333435

This project will challenge you to set up replication on your SQL Server installation. Every step to complete this process is not laid out for you here. Complete the steps and document your choices throughout the process with screen shots and explanations.

1.Begin by enabling your SQL Server 2000 installation for replication by using the "Configure Publishing, Subscribers, and Distribution" selection from the Tools->Replication menu item.

o Provide explanations of your process and provide a screen shot of the last wizard frame.

2.Create a publication by opening the "Create and Manage Publications" wizard from the Tools->Replication menu item.

oYou should select Snapshot replication as the type of replication.

oYou should publish the Region and Shippers tables from the Northwind database.

3.Create a subscription by opening the "Create and Manage Publications" wizard from the Tools->Replication menu item.

oThe "Push New Subscription" option should be available. Select this option.

oCreate a new destination database for the subscription called nWindSubscriber.

oBe sure to take a screen shot of the last wizard frame.

4. Demonstrate replication by adding a couple of rows to both the Region and Shippers tables in the Northwind database.

oVerify that replication occurred by opening the nWindSubscriber database you created and opening the Region and Shippers tables and seeing if the rows you added appear in the other database.

oIf the rows are not present, make sure the Snapshot Agent was started.

oProvide screen shots of the nWindSubscriber tables with the new rows added, as well as a screen shot of the "Latest History of Snapshot Agent" window, it should show the articles generated.

Your assignment should include screen shots and explanations.

Reference no: EM1333435

Questions Cloud

Examine present global economic and political policies : Examine present global economic and political policies and their impact on business decisions.

Principle of respondeat superior : Does the principle of respondeat superior create unfair expectations for business in the United States?

Recording journal entry establishing the note : Please record the appropriate journal entry establishing the note on McNamee's books.

Constant interest coverage policy and leveraged value : How is the levered value of the project impacted by the constant interest coverage policy?

Opening the "create and manage publications" : This project would challenge you to set up replication on your SQL Server installation. Every step to complete this process is not laid out for you here. Complete the steps and document your choices throughout the process with screen shots and exp..

Illustrate what is the highest price pay for this stock : If you need a rate of return. Illustrate what is the highest price I should be willing to pay for this stock.

Potential challenges to validity and reliability of business : Explain potential challenges to validity and reliability of business research questions, analysis and data.

Preventing the copyright infringement : Do you think that acknowledging the source of the copyrighted material can be substituted for obtaining permission.

Compound interest and investment growth : Assume that $ 750 is invested at 7%interested, compounded semiannually. Given that A=(1+r/n)^nt-Find out the amount of money in the at t=1,6,10,15 and 25 years

User Account

All Pages