We have a databased hosted with a "commodity" SQL hosting company. It's currently hosted on a SQL 2005 server.
We have just configured a dedicated server (to which we have "root" access) running SQL 2008.
Unfortunately, getting a backup file of the SQL 2005 database takes upwards of 3-4 days from the support team.
Is there a better way to connect to our SQL 2005 database, "download" the entire database set, and "import" that data to SQL 2008?