Shulou(Shulou.com)06/01 Report--

Editor to share with you the method of converting Access database into SQL Server. I hope you will gain a lot after reading this article. Let's discuss it together.

Over time, the size and complexity of most databases are growing. If the Access 2010 database becomes too large or too clumsy, you may need to allow more powerful multi-user access to the database. Converting an Access database to Microsoft SQL Server may be the solution you need.

Fortunately, Microsoft provides an upgrade wizard in Access 2010 that makes it easy to convert databases. This tutorial will introduce the process of converting a database.

What do you need

1.Microsoft Access 2010

2.Microsoft SQL Server

3. Relational database

4. SQL Server administrative account with permissions to create database

Preparation for upgrading Access database

1. Before you begin the tutorial on converting a database to an SQL Server database, you need to do a few things:

two。 Backup database

3. Make sure there is enough disk space on the device to accommodate the upgraded database

4. Assign your own permissions to the SQL Server database

5. Add a unique index for each Access table that does not have an Access table before promotion

Convert Access 2010 database to SQL Server

1. Open the database in Microsoft Access.

two。 Select the Database tools tab on the ribbon.

3. Click the SQL Server button in the move data section. This will open the promotion wizard.

4. Choose whether you want to import data into an existing database or create a new database for the data. For this tutorial, suppose you try to create a new SQL Server 5 database using data from the Access database. Click next to continue.

5. Provides connection information for the SQL Server installation. You need to provide the name of the server, the credentials of the administrator who has permission to create the database, and the name of the database to connect to. Click next after providing this information.

6. Use the arrow buttons to move the transferred table to the list labeled Export to SQL Server. Click the next button to continue.

7. View the default properties to be transferred and make any changes you want. You can choose to keep the table index, verify the settings for rules and relationships, and other settings. When you are finished, click the next button to continue.

8. Determine how to handle the Access application. You can choose to create a new Access client / server application to access the SQL Server database, modify an existing application to reference data stored on SQL Server, or copy the data without making any changes to the Access database.

9. Click finish and wait for the promotion process to complete. When you are finished, review the promotion report for important information about database migration.

After reading this article, I believe you have a certain understanding of the method of converting Access database into SQL Server. You want to know more about it. Welcome to follow the industry information channel. Thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.