question Re: best way to migrate acess data base to another effective one? in Archives of Support Questions (Read Only)

best way to migrate acess data base to another effective one?

sayhipriya1003 — Mon, 01 Aug 2016 17:14:49 GMT

I have a business case to move my entire access data base to any other data base which has the best performance. Can anyone please help me with the suggestion. Is SQL db is the best source to migrate or is there any other alternative. Can anyone help me with the step which must be using for migration

Re: best way to migrate acess data base to another effective one?

hduraiswamy — Mon, 01 Aug 2016 19:35:13 GMT

How big is your access database? and why are you trying to migrate?

It sounds like you will be better served my moving to MySql - here are the steps to migrate from access to mysql - https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-export.html

If you want to explore Bigadata, then you can perhaps move to Hive using Sqoop.. but can't really recommend with certainty without knowing the size or use cases.

Re: best way to migrate acess data base to another effective one?

sayhipriya1003 — Fri, 05 Aug 2016 02:37:16 GMT

I am not sure about the size. They must be ODBC tables connected to them. I must be 1GB or so