In the company I worked:

MSSQL database has previusly been archive on another database. Approximately 70m rows. (Includes sales information.)

Now, asked to move these archive data to live database. Because, we customer can't see order history older the 3 years.

Is it reasonable to do this? I think it will be slow. Are there other solutions?

Live DB size : 250GB

Archive DB size : 50GB

CPU : 8 Core

Memory : 64GB

Version : Microsoft SQL Server 2016 (SP1)

MSSQL database has previously been archived on another database. Approximately 70m rows (includes sales information.)

Now, I am asked to move this archived data to live database. Because, customer can't see order history older the 3 years.

Is it reasonable to do this? I think it will be slow. Are there other solutions?

• Live DB size : 250GB
• Archive DB size : 50GB
• CPU : 8 Core
• Memory : 64GB
• Version : Microsoft SQL Server 2016 (SP1)