How can I migrate from MS Access 2000 to SQL Server 2000? How can I migrate the forms from Access to SQL Server?

You can easily migrate Access data into SQL Server using Data Transformation Services. All you need to do is create a database on SQL Server that will be the target for the data. Then follow these steps using Enterprise Manager:

Right-click the target database and select Import Data.

Pick Microsoft Access as the Source in the Choose a Data Source dialog box.

Microsoft also provides the MS Access Upsizing Wizard. To invoke the Upsizing Wizard, go to the Tools menu, point to
Database Utilities, and then click
Upsizing Wizard. Read these documents to get familiar with all the ins and outs of the Upsizing Wizard:

According to the Microsoft Small Business Server 2000
Resource Kit, there are a lot of issues when migrating your Forms from Access to SQL Server. The easiest route is to point your Access Forms at the new SQL Server database and then test them. The SBS Res Kit contains details about the various aspects of migrating forms and queries.

You might to read the white paper Managing SQL Server 2000 after Migrating Multiple Access Databases to a Single...

By submitting my Email address I confirm that I have read and accepted the Terms of Use and Declaration of Consent.

By submitting your personal information, you agree to receive emails regarding relevant products and special offers from TechTarget and its partners. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

Server. It contains useful information tips and advice for administrating and maintaining a single SQL Server where many Access databases have been consolidated.

0 comments

E-Mail

Username / Password

Password

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy