Hi
Ahmed B. Sokni,
As
Tom van Stiphout (MVP) and
Bill Mosca already suggested to use SSMA.
you can also try to check Access Upsizing Wizard.
Over time, most database applications grow, become more complex, and need to support more users. At some point in the life of your Microsoft Office Access application, you might want to consider upsizing to it to a Microsoft SQL Server database to optimize
performance, scalability, availability, security, reliability, and recoverability.
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.
References:
Move Access data to a SQL Server database by using the Upsizing Wizard
Regards
Deepak
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com.
