Question: Assume that the Multiple Listing Service that is under development will replace an existing system developed many years ago. The database requirements and design for

Assume that the Multiple Listing Service that is under development will replace an existing system developed many years ago. The database requirements and design for the old and new systems are very similar. Unfortunately, the existing system stores its data in a Microsoft Access database, which provides little support for simultaneous access and updates by multiple users. An important reason for replacing the current system is to upgrade to a DBMS that can easily support many simultaneous accesses.

The current plan is to use Microsoft SQL Server as the new DBMS and to migrate all data from the existing Microsoft Access database immediately prior to full deployment. Perform these tasks to prepare for this migration:

1. Investigate data migration from Microsoft Access to SQL Server. What tools are available to assist in or perform the migration? If there are multiple possible tools, which should you use and why?

2. Develop plans to test the migration tools/strategy in advance of full deployment. When should the test be performed, and how will you determine whether the test has been “passed”?

Step by Step Solution

★★★★★

3.38 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 Microsoft Access Upsizing Wizard Microsoft SQL Server Migration Assistant SSMA for various databas... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (2 attachments)

1811_60b8c12187001_726576.pdf

180 KBs PDF File

1811_60b8c12187001_726576.docx

120 KBs Word File

Students Have Also Explored These Related Systems Analysis Design Questions!

1. To what events must the multiple listing service system respond? Create a complete event table listing the event, trigger, source, use case, response, and destination for each event. 2. Draw an...

Create a set of use cases for the following system: A Real Estate, Inc. (AREI), sells houses. People who want to sell their houses sign a contract with AREI and provide information on their house....

Create a physical level 0 DFD for the following, and compare it with the logical model that you created in Chapter 5: A Real Estate Inc. (AREI) sells houses. People who want to sell their houses sign...

ANSWER QUESTIONS 1. What are the five activities of systems analysis, and which activity is discussed beginning with this chapter? 2. What is a user story? What is a use case? 3. What are the two...

ANSWER QUESTIONS 16. Define a temporal event and give an example that applies to a checking account system. 17. What are system controls, and why are they not considered part of the users' functional...

ANSWER QUESTIONS 21. What is UML? 22. What is the purpose of UML use case diagrams? 23. What is another name for "actor" in UML, and how is it represented on a use case diagram? 24. What is the...

ANSWER QUESTIONS 1. What are the five activities of systems analysis, and which activity is discussed beginning with this chapter? 2. What is a user story? What is a use case? 3. What are the two...

ANSWER QUESTIONS 11. What is an elementary business process (EBP)? 12. Explain how the event decomposition technique helps identify use cases at the right level of analysis. 13. What is an event? 14....

Project Management Casebook David I. Cleland, Karen M. Bursic, Richard Puerzer, and A. Yaroslav Vlasak Library of Congress Cataloging-in-PublicationData Project management casebook /edited by David...

Southwest Bankers, Inc. (not it's real name) through its subsidiaries, provides financing for industrial and commercial properties, for interim construction related to industrial and commercial...

Aaron Grider buys a home for $120,500. After a 15% down payment, the balance is financed at 8% interest for 9 years. a. What equal quarterly payments will be required to amortize this mortgage loan?...

A manufacturing plant make wind mill assemblies & can produce 50 units in a month in two period of 15 days each ; following is the data for number of defects arising per month. Month JAN FEB MAR APR...

1 2 3 4 5 6 Select your answer ( 1 out of 6 ) What is the slope of the line defined by the equation y = 3 x + 4 ?

2. Use a unit cost factor to estimate preliminary cost. Unit method

Assume that RMO plans to change its pricing policy. If two or more catalogs are in circulation at the same time, then all item prices in the catalogs must be the same. Prices can still rise or fall...

Assume that RMO will begin asking a random sample of customers who order by telephone about purchases made from competitors. RMO will give customers a 15 percent discount on their current order in...

Assume that RMO is developing its database using object-oriented methods. Assume further that the database designers want to make some changes to the class diagram in Figure (a). Specifically, they...

Brett is a 26 year-old researcher at Texas Parks and Widlife. He makes 558,000 per vear. Your firm uses an end age of 95 and a top-down ratio of 77%. Brett has 1 kid and wants to have another. Hed...

(Complex annuity) Upon graduating from college 35 years ago, Dr. Nick Riviera was already thinking of retirement. Since then, he has made deposits into his retirement fund on a monthly basis in the...

The following table presents information on four different open-end mutual funds. Use the information in the table to answer the questions that follow. The mutual fund True or False: YoI True False...