Ok, officially this one is messing with my head. I had the worst idea to try out the SQL server Denali CPT3 when it came out on our development environment. And it seemed ok so we used and gathered a couple of databases on it.
Now we have an instance of SQL 2008 R2 and the team that was working on the Denali instance want's to switch to 2008 R2.
My task is to copy the database from the Denali instance to the 2008 R2 instance, but it proves to be a more difficult job than I thought. I have tried to attach the database using the mdf and ldf files but it didn't work. I have tried to backup from denali but it didn't work. I have tried to export/import the databases but it didn't work. I have tried to copy the database but it failed. The only thing seemed to slightly work was to generate scripts on the denali instance and run them in the 2008 R2 instance, but it fails when i try to generate for all the objects of the database.
I am wandering if there is some other solution that could work or if one of the solutions that i've tried should work and i need to pay more attention to it. I'm open to "crazy" solutions like transferring to mysql or oracle if possible (even csv or flat file, anything that makes possible the transfer of the whole database).