Results 1 to 2 of 2
  1. #1
    HansBades is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    85

    Migration

    How would you migrate an Access dbase to Microsoft SQL Server? How do you split the dbase to be like a multi-tenant application so you can license it to different entities? Thanks.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    split the db while it still uses Access tables,
    then in the FE, relink the tables to the SQL tables.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Migration of Access 365 to SharePoint
    By fzxxx in forum SharePoint
    Replies: 0
    Last Post: 01-13-2021, 10:09 AM
  2. Migration of sharepoint to SQL server
    By meena16 in forum SQL Server
    Replies: 0
    Last Post: 01-14-2020, 01:51 AM
  3. migration from 2010 to 2016
    By leonardo.massei in forum Access
    Replies: 3
    Last Post: 11-03-2016, 10:34 AM
  4. Migration to web
    By thbaig1 in forum Access
    Replies: 1
    Last Post: 11-22-2010, 10:04 AM
  5. launching migration script
    By MrGrinch12 in forum Programming
    Replies: 0
    Last Post: 06-23-2010, 08:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums