We have 32 bit SQL Server 2005 running on an old 32bit Server 2007 which started out as part of a turn-key system. Over time, the turn-key system has been discontinued and we've developed new databases and tables for use in the replacement system. See attached image -- all the databases beginning with HPRS are for the new system (really only HPRS, the others are yearly archives), and all the other databases (OSH*, ST, SYS) are from the legacy turn-key system.
The time has come to moth-ball the legacy software and databases. What I'd like to do is clone-off the entire TRAVERSE105 instance, databases, tables, users, privileges, server agent jobs, ... everything, to another computer. I would then remove the new databases from that copied instance stripping it down to just the legacy databases -- for backup reference in case we ever need to look anything up. I would then be free to likewise remove the legacy databases from the production system and ultimately upgrade it to 64bit SQL Server 2014.
Is there a way to do this?