I cant import my tables in SSMA. I have 15 Tables in my access database, but only one table appers
Like you see in this screenshot
I checked the informations from these thread, also the youtube video(clicked through).
access-programmers.co.uk/forums/threads/sql-server-migration-assistent-for-access-not-all-table-from-access.330695
The SSMA Part didnt helped, cause there where no problems like that. The VBA Method would be maybe an option, seems more complicated (where can i download, the link unter youtubevideo leed to no specific file)
I read before the introduction of microsoft for the migration process.
The database is running without any problems in daily use. Wanna get it on azure SQL Server, cause of availability from "outsite" and use it with feature from azure (combination of OCR and Power Plattform)
What is functioning:
- SSMA is functioning, its related to my database, cause
What i tried (without sucess):
- new accdb's with copied in tables:
- Instant of SSMA, i tried Upsizing Wizard (crys about different SQL Version)
Any Ideas what and where i can check, whats the problem ist. I could imagine its a problem of access rights, or something like that is blocking SSMA.
Like you see in this screenshot
I checked the informations from these thread, also the youtube video(clicked through).
access-programmers.co.uk/forums/threads/sql-server-migration-assistent-for-access-not-all-table-from-access.330695
The SSMA Part didnt helped, cause there where no problems like that. The VBA Method would be maybe an option, seems more complicated (where can i download, the link unter youtubevideo leed to no specific file)
I read before the introduction of microsoft for the migration process.
The database is running without any problems in daily use. Wanna get it on azure SQL Server, cause of availability from "outsite" and use it with feature from azure (combination of OCR and Power Plattform)
What is functioning:
- SSMA is functioning, its related to my database, cause
- Northwind Test DB is fully avaiable in SSMA (Tables and queries)
- also the queries of my database are avaiable
What i tried (without sucess):
- new accdb's with copied in tables:
- "played" around with datatypes
- only one table
- delete any relationship
- removed index'
- each above without any datas
- Instant of SSMA, i tried Upsizing Wizard (crys about different SQL Version)
Any Ideas what and where i can check, whats the problem ist. I could imagine its a problem of access rights, or something like that is blocking SSMA.