SQL Replication
Not what you're looking for?
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.
Purchase this Solution
Solution Summary
Setting up replication on a SQL Server installation is explained.
Purchase this Solution
Free BrainMass Quizzes
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
C# variables and classes
This quiz contains questions about C# classes and variables.
Basic Networking Questions
This quiz consists of some basic networking questions.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.