on 2014 May 03 5:45 PM
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.
Thanks Breck,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
11 | |
10 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.