Migrating to SQL from Access

%3CLINGO-SUB%20id%3D%22lingo-sub-2765492%22%20slang%3D%22en-US%22%3EMigrating%20to%20SQL%20from%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2765492%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20about%20to%20hit%20the%20Access%202Gb%20database%20file%20size%20limit.%26nbsp%3B%20I%20would%20like%20to%20migrate%20my%20Access%20db%20to%20SQL%20Server%20using%20the%20SQL%20Server%20Migration%20Assistant%20for%20Access.%26nbsp%3B%20However%2C%20the%20documentation%20has%20the%20filing%20caveat%3A%3C%2FP%3E%3CUL%20class%3D%22%22%3E%3CLI%3E%3CP%3E%3CSTRONG%3ERemove%20the%20Attachment%20column%3C%2FSTRONG%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20SSMA%20doesn't%20migrate%20tables%20that%20contain%20the%20Attachment%20column.%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fmigrate-an-access-database-to-sql-server-7bac0438-498a-4f53-b17b-cc22fc42c979%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fmigrate-an-access-database-to-sql-server-7bac0438-498a-4f53-b17b-cc22fc42c979%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20Access%20db%20has%20hundreds%20of%20file%20attachments.%26nbsp%3B%20How%20can%20I%20migrate%20the%20Access%20db%20to%20SQL%3F%26nbsp%3B%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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-4f...

 

This Access db has hundreds of file attachments.  How can I migrate the Access db to SQL?  Thank you.

0 Replies