Monday, 13 February 2017

MS Access Databased Migration to Sharepoint and SQL Server

Two way of Access Database Migration:
  1. Using sharepoint Access web app.
  2. Using Microsoft SQL Server Migration Assistant v6.0 for Access Tools.
1. Using sharepoint Access web app: 
  • Login to O365 account.
  • Click on Site Contents
  • Click on Add an app
  • In the search control, perform a search for ‘Access   
  • Click on Access App
  • Once the App loads, Click on Settings (the Gear in the top right-hand corner)
  • Click on Customize in Acces
  • At the bottom of the Access screen, Click on Access (assuming your be is an Access database) from the Create a table from an existing data source menu  
  • Go to the File tab and click on Manage (under the Connections)
  • The following menu/dialog will appear.  Click on From Any Location, as well as, Enable Read-Write Connection.
  • Click on click on View Read-Write Connection Information.     
Reference : https://www.youtube.com/watch?v=4tpgX2tQDBE
                   http://www.devhut.net/2014/01/13/how-to-hybridize-your-ms-access-database-in-office-365-azure-database/


2. Using Microsoft SQL Server Migration Assistant v6.0 for Access Tools.
        SQL Server Migration Assistant (SSMA) for Access lets you quickly convert Access database objects to SQL Server or Azure SQL DB objects

 

No comments:

Post a comment