Sql-server – Issue migrating from SQL Server 2008 R2 to SQL Server 2017 Standard (on Linux)

linuxmigrationsql serversql-server-2008-r2sql-server-2017

I am currently trying to carry out a database migration from SQL Server 2008 to SQL Server 2017 (Linux) using the DMA tool.

I get the all green after running the assessment, however I get hit with an "out of memory" exception during the migration process.

Any advice on how I can resolve this issue? Both source and destination servers have 16GBs of RAM. This should be sufficient, no?

Best Answer

There is a similar, but not exactly the same, question here:

Azure SQL Data Migration Assistant is Stuck on "Migrate Data"

However, it does explain the limitation you're hitting:

The Extract service connects to a database, reads all of its objects and their properties, and then creates an in-memory model of the database.

If the database you're trying to migrate has an exceptional number of schema objects, this in-memory DAC model potentially overwhelms the client application / system (Data Migration Assistant running on your PC in this case), resulting in the OutOfMemoryException.

Your next best bet would be to use tried and true approaches like backup / restore in order to migrate to the new machine.

Related Question