Migrate database from Hyper-V to VMware
-
We are planning on upgrading our ERP environment (which is separate from our house environment). All of the servers are being built new 2016 and the ERP vendor is going to install their software. We are going from Hyper-V 2012 to VMware vSphere 6.5U2 because that is what the ERP vendor supports. We have and use Veeam B&R 9.5 for our backups across both environments.
Question is, could I replicate the data from the database from Hyper-V to vSphere through Veeam? Is there another, better option?
-
What database are you asking about?
-
@scottalanmiller said in Migrate database from Hyper-V to VMware:
What database are you asking about?
MS SQL
-
Why not back up through normal MS SQL means and restore using its own tools?
-
I'm guessing he is wanting to migrate the entire VM rather than just the database, hence the question.
But I'd agree using the MS SQL backup and restore approach would likely be best.
The next option down from that would be to export the VM and import it into VMWare, but you'll likely need to convert the disks to whatever VMWare supports.
-
Why not just use VMware Standalone Converter to convert the VHD/X to VMDK?
-
@scottalanmiller said in Migrate database from Hyper-V to VMware:
Why not back up through normal MS SQL means and restore using its own tools?
This will probably be our best avenue.
@dustinb3403 said in Migrate database from Hyper-V to VMware:
I'm guessing he is wanting to migrate the entire VM rather than just the database, hence the question.
But I'd agree using the MS SQL backup and restore approach would likely be best.
The next option down from that would be to export the VM and import it into VMWare, but you'll likely need to convert the disks to whatever VMWare supports.
We're actually going to build new 2016 servers. So, we're just going to migrate the data.
The biggest problem of all of this is going to be finding the downtime to migrate all of the data from the old system to the new system. We're looking at 1 TB of data including the database and all of the transaction logs.
-
@nerdydad said in Migrate database from Hyper-V to VMware:
@scottalanmiller said in Migrate database from Hyper-V to VMware:
Why not back up through normal MS SQL means and restore using its own tools?
This will probably be our best avenue.
@dustinb3403 said in Migrate database from Hyper-V to VMware:
I'm guessing he is wanting to migrate the entire VM rather than just the database, hence the question.
But I'd agree using the MS SQL backup and restore approach would likely be best.
The next option down from that would be to export the VM and import it into VMWare, but you'll likely need to convert the disks to whatever VMWare supports.
We're actually going to build new 2016 servers. So, we're just going to migrate the data.
The biggest problem of all of this is going to be finding the downtime to migrate all of the data from the old system to the new system. We're looking at 1 TB of data including the database and all of the transaction logs.
Can't you sync the databases?
-
@black3dynamite said in Migrate database from Hyper-V to VMware:
@nerdydad said in Migrate database from Hyper-V to VMware:
@scottalanmiller said in Migrate database from Hyper-V to VMware:
Why not back up through normal MS SQL means and restore using its own tools?
This will probably be our best avenue.
@dustinb3403 said in Migrate database from Hyper-V to VMware:
I'm guessing he is wanting to migrate the entire VM rather than just the database, hence the question.
But I'd agree using the MS SQL backup and restore approach would likely be best.
The next option down from that would be to export the VM and import it into VMWare, but you'll likely need to convert the disks to whatever VMWare supports.
We're actually going to build new 2016 servers. So, we're just going to migrate the data.
The biggest problem of all of this is going to be finding the downtime to migrate all of the data from the old system to the new system. We're looking at 1 TB of data including the database and all of the transaction logs.
Can't you sync the databases?
Something else to look into. I've considered replicating all of the data over from old to new and then, over a weekend, failing over to the new and reversing the replication.
-
Make sure if you do backup the SQL databases and restore that the security gets backed up and restored as well. I've seen instances where a database was restored along with security permissions on the database, but there were no SQL logins created on the target instance to map to the restored database permissions.
-
@networknerd Along this line I jsut dealt with a backup and restore last week where the SQL log ins were created after the database was reqtored and the SQL login in the database had to be deleted and then permisisons reapplied to the database form the mian login securty settings for the SQL user.
-
@nerdydad One does not simply replicate data to disparate systems with Veeam.
While it may be entirely possible, I would never try it.
Use SQL's replication features.
-
@nerdydad said in Migrate database from Hyper-V to VMware:
We're looking at 1 TB of data including the database and all of the transaction logs.
1TB of data or 1TB of transaction logs? Your transaction logs should be tiny if you schedule this after a backup.
-
@jaredbusch said in Migrate database from Hyper-V to VMware:
@nerdydad said in Migrate database from Hyper-V to VMware:
We're looking at 1 TB of data including the database and all of the transaction logs.
1TB of data or 1TB of transaction logs? Your transaction logs should be tiny if you schedule this after a backup.
1 TB of data. A little bit more than 500 GB of transaction logs on the database.
-
@nerdydad said in Migrate database from Hyper-V to VMware:
@jaredbusch said in Migrate database from Hyper-V to VMware:
@nerdydad said in Migrate database from Hyper-V to VMware:
We're looking at 1 TB of data including the database and all of the transaction logs.
1TB of data or 1TB of transaction logs? Your transaction logs should be tiny if you schedule this after a backup.
1 TB of data. A little bit more than 500 GB of transaction logs on the database.
So that is 1.5 TB to transfer. also WTF on 500 GB of transaction logs. What kinds of rollbacks are you trying to be able to handle.
-
@jaredbusch said in Migrate database from Hyper-V to VMware:
@nerdydad said in Migrate database from Hyper-V to VMware:
@jaredbusch said in Migrate database from Hyper-V to VMware:
@nerdydad said in Migrate database from Hyper-V to VMware:
We're looking at 1 TB of data including the database and all of the transaction logs.
1TB of data or 1TB of transaction logs? Your transaction logs should be tiny if you schedule this after a backup.
1 TB of data. A little bit more than 500 GB of transaction logs on the database.
So that is 1.5 TB to transfer. also WTF on 500 GB of transaction logs. What kinds of rollbacks are you trying to be able to handle.
They are merged into the database nightly. This systems manages everything between our accounting, to customer service, to raw materials, to boxing and shipping.
-
@nerdydad said in Migrate database from Hyper-V to VMware:
@jaredbusch said in Migrate database from Hyper-V to VMware:
@nerdydad said in Migrate database from Hyper-V to VMware:
@jaredbusch said in Migrate database from Hyper-V to VMware:
@nerdydad said in Migrate database from Hyper-V to VMware:
We're looking at 1 TB of data including the database and all of the transaction logs.
1TB of data or 1TB of transaction logs? Your transaction logs should be tiny if you schedule this after a backup.
1 TB of data. A little bit more than 500 GB of transaction logs on the database.
So that is 1.5 TB to transfer. also WTF on 500 GB of transaction logs. What kinds of rollbacks are you trying to be able to handle.
They are merged into the database nightly. This systems manages everything between our accounting, to customer service, to raw materials, to boxing and shipping.
So if you schedule your downtime for post merge, then you only have 1TB to move.
-
As for how to do this.
I would simply schedule extended downtime after backups run, shut down the database access and migrate the backup file.
Obviously, this would be done after simply spinning up the new system with a backup file and confirming any other steps that you need to take.
You have no HA now, why try to implement some half baked HA just to migrate?
-
Could you restore the backup on the new server whilst the old server is still live and after it is restored on the new server shut down live and do a differential backup and then restore the differential backup on the new server?
That would minimise downtime as the differential backup will be much smaller than the full 1TB backup. Although with 500gb of transaction logs, maybe not so much.
-
Last year I moved a Vm from HyperV to Vmware, It had Sql Server with a database of 300Gb, for Ms Ax.
I just stopped all Ms Sql Server services and migrated using VMware Standalone Converter.
After the migration I started all Sql services again and everything worked.
