How Do I Migrate 100 DBs From One MS-SQL 2008 Server To Another? (looking for automation)
- by jc4rp3nt3r
Let me start by saying that I am not a DBA, but I am in a position where I am responsible for moving just under 100 MS-SQL 2008 DBs from our current development server, to a new/better/faster development server.
As this is just a local dev server, temporary downtime is acceptable, but I am looking for a way to move all of the databases (preferably in bulk).
I know that I could take a bak of each, and restore it on the new server, but given the volume of DBs, I am looking for a more efficient way.
I am not opposed to learning a new piece of software, writing code or any other requirement, so long as it speeds up the process.