What is the best way to do this? File locations will be different on new server.<BR><BR>Should I SP_DETACH_DB the source DB, copy over the .mdf/.ldf files, then SP_ATTACH_DB on destination server with ...

i have two servers, each with a mysql instance. the "old" server has a couple of db instances that i want to migrate. aside from stopping the service, and scp'ing the files in /var/lib/mysql from old ...

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...