none
How to convert Access 2010 database to the SQL Server database RRS feed

All replies

  • Best way is to use MSFT's SQL Server Migration Assistant.

    -Tom. Microsoft Access MVP

    Monday, May 1, 2017 1:42 PM
  • The SSMA can be downloaded from here: 
    SSMA

    Information and instruction here:
    How-To

    And I have written an article with some tips on using a SQL Server database as a back end here:

    Working with SQL Server Linked Tables: The Hidden Gotchas


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Monday, May 1, 2017 2:11 PM
  • 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:

    1. Open the database in Microsoft Access.
    2. Choose the Database Tools tab in the Ribbon.
    3. Click the SQL Server button located in the Move Data section. This opens the Upsizing Wizard.
    4. 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.
    5. 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.
    6. 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.
    7. 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.
    8. 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.
    9. 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.



    Monday, May 8, 2017 5:36 AM
    Moderator
  • Seems simple 
    Wednesday, October 24, 2018 7:20 PM