I installed SQL Anywhere 16 Developer and need to import almost 200 Tables originating in Microsoft Access. I have tried the following:
Is there an easy way "import" tables into SQL Anywhere from MS SQL Server database? The migration tool is a little confusing and I am a "newbie" to writing source code.
In google searching, I see lots of information for importing from SQL Anywhere to SQL Server but not much on importing from SQL Server to SQL Anywhere. I need an easy solution so I can move on to other design & visual basic programming tasks.
I figured it out on my own after doing something else and letting my subconscious think about how to do it.
I used the Open ODBC Administrator to create an ODBC source file (64-Bit) pointing to the Access database I wanted to import into SQL Anywhere 16.
Then I used the Migration Wizard to connect to the Access ODBC source file and selected "all tables" - it worked great!
My last step was to delete all "Proxy" tables.
Bob Sheridan www.acuity-pos-systems.com
answered 03 May '14, 21:10