Forum Discussion
EMR88
Sep 19, 2021Copper Contributor
Migrating to SQL from Access
I am about to hit the Access 2Gb database file size limit. I would like to migrate my Access db to SQL Server using the SQL Server Migration Assistant for Access. However, the documentation has the filing caveat:
Remove the Attachment column SSMA doesn't migrate tables that contain the Attachment column.
https://support.microsoft.com/en-us/office/migrate-an-access-database-to-sql-server-7bac0438-498a-4f53-b17b-cc22fc42c979
This Access db has hundreds of file attachments. How can I migrate the Access db to SQL? Thank you.
No RepliesBe the first to reply