Database migration from MS Access to SQL

Question

we need to convert Access DB to an SQL technology to make it more robust.we may also want to keep the existing Access front end. What approx time it will take to perform full migration task.

Answer 1

Hi,

Full migration will depend on a number of factors:

• Number of tables to migrate?
• How big are these tables?
• Number of additional SQL server objects to be created?
• Are you going to use upsizing wizard or data imports?
• Are the Access database and SQL Server in the same datacentre?

Thanks.

---

Kind regards, Kev

Answer 2

You can automate your migration tasks using DBConvert for Access and MS SQL

Answer 3

Hi ^_^

you can us 

Microsoft SQL Server Migration Assistant v5.3 for Access

https://www.microsoft.com/en-us/download/details.aspx?id=42656

it would take you few hours if your data is so big

if it small it may take a few minutes