Scripting a database copy from MS Sql 2005 to 2008 without detach/backup/RDP
- by James Santiago
My goal is to move a single SQL 2005 database to a seperate 2008 server. The issue is my level of access to both servers. On each I can only access the database and nothing else. I cant create a backup file or detach the database because I don't have access to the file system or to create a proxy.
I've tried using the generate script function…