Science, Tech, Math › Math Converting an Access Database to SQL Server Share Flipboard Email Print Mike Chapple Math Statistics Statistics Tutorials Formulas Probability & Games Descriptive Statistics Inferential Statistics Applications Of Statistics Math Tutorials Geometry Arithmetic Pre Algebra & Algebra Exponential Decay Functions Worksheets By Grade Resources View More By Mike Chapple Writer University of Idaho Auburn University Notre Dame Former Lifewire writer Mike Chapple is an IT professional with more than 10 years' experience cybersecurity and extensive knowledge of SQL and database management. our editorial process Twitter Twitter Mike Chapple Updated July 13, 2019 In time, most databases grow in size and complexity. If your Access 2010 database is growing too large or unwieldy, you may need to allow more robust multiuser access to the database. Converting your Access database to Microsoft SQL Server database might be the solution you need. Fortunately, Microsoft provides an Upsizing Wizard in Access 2010 that makes it easy to convert your database. This tutorial walks through the process of converting your database. It's important to note that if you're looking for a SQL Server tool that offers a similar migration path, you need to look at the SQL Server Migration Assistant. What You Need Microsoft Access 2010Microsoft SQL ServerRelational DatabaseSQL Server administrative account with permission to create a database Preparations for Upsizing an Access Database Before you begin the tutorial to convert your database to a SQL Server database, you need to do a few things: Back up the databaseMake sure you have plenty of disk space on the device that will contain the upsized databaseAssign yourself permissions on the SQL Server databaseAdd a unique index to each Access table that doesn't have one before you upsize it Converting an Access 2010 Database to SQL Server Open the database in Microsoft Access.Choose the Database Tools tab in the Ribbon.Click the SQL Server button located in the Move Data section. This opens the Upsizing Wizard.Select whether you want to import the data into an existing database or create a new database for the data. For this tutorial, assume that you're trying to create a new SQL Server database using the data in your Access database. Click Next to continue.Provide the connection information for the SQL Server installation. You'll need to provide the name of the server, credentials for an administrator with permission to create a database and the name of the database you want to connect. Click Next after providing this information.Use the arrow buttons to move the tables you want to transfer to the list labeled Export to SQL Server. Click the Next button to continue.Review the default attributes that will be transferred and make any changes desired. You have the option to preserve settings for table indexes, validation rules, and relationships, among other settings. When done, click the Next button to continue.Decide how you want to handle your Access application. You may choose to create a new Access client/server application that accesses the SQL Server database, modify your existing application to reference the data stored on SQL Server, or copy the data without making any changes to your Access database.Click Finish and wait for the upsizing process to complete. When you are finished, review the upsizing report for important information about the database migration. Tips This tutorial was written for Access 2010 users. The Upsizing Wizard first appeared in Access 97 but the specific process for using it varies in other versions.