question

rintelltechnologies avatar image
0 Votes"
rintelltechnologies asked rintelltechnologies commented

Using SQL Server Migration Assistant for Access with file attachments

I have a large Access db filled with file attachments that is close to the Access 2Gb file size limit. I would like to use the SQL Server Migration Assistant for Access to move the Access db to SQL, but when I began researching the process I noticed this limitation:

 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

Any advice/tips on how I can migrate my Access db to SQL with the file attachments? Thanks.

sql-server-migrationsql-server-migration-assistant
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hey,

The article you referred to mentions the following for the attachment data type:

In SQL Server, you have several options to consider. You can extract the files from the Access database and then consider storing links to the files in your SQL Server database. Alternatively, you can use FILESTREAM, FileTables, or Remote BLOB store (RBS) to keep attachments stored in the SQL Server database.

While SQL Server supports varbinary data type, general recommendation is to keep BLOBs outside of the relational database.

Regards,
Alex.

0 Votes 0 ·

Alex---

Thanks for your post; I missed that. I wonder if an easier path is to skip SQL and simply create another Access db. What I was hoping for a solution where I could use Access as a front end to a SQL db.

0 Votes 0 ·

0 Answers