We are currently running SQL Server 2008 R2 and want to upgrade to 2014 but we need to leave some DBs at 2008 so we have decided to create a separate 2014 server and just migrate some DBs to it. Is there a way to script all the server settings such as Linked servers, users, scheduled jobs without doing each one individually? Can I clone or copy the whole instance somehow. Is there a better way to do this?
Aucun commentaire:
Enregistrer un commentaire