Hi all,
I am working in a data migration project where i have to migrate multiple databases from one server to another server(Eg. SQL server 2012 to SQL server 2014). I have already created a flow chart for migration and validation for single instance. Here i need to migrate multiple databases with different instances and i want to parametrise the instance values using an excel sheet so that it can take all the instances names from excel and connect automatically and start migration. Kindly suggest if there is any other way i can handle this (Have an idea about using orchestrator but not sure about this idea) and help me to solve this. There are around 2000 different databases and i have to migrate to a single one. Please help.
Thank you…