I am in the process of planning for a migration.
I have about 10TB of data in my Transaction database which I want to migrate to an empty database on a new server.
I know a backup and restore would take a very long time. I also want to minimise downtime as much as possible.
Is there any way this can be done with minimal downtime?