Downgrade SQL Server 2008 r2 to SQL Server 2008

I need to upload a .bak file to SQL Server.开发者_开发问答 How can I downgrade the database from SQL Server 2008 R2 to SQL Server 2008

thanks

You cannot. Period. That's never been possible with SQL Server (and most likely never will be).

If you have a database backup file from a 2008 R2 version, you cannot under any circumstances and with any tricks or tools restore that into a 2008 version. Just cannot be done.

You need to either find a way to do this using scripting (e.g. script out the SQL structure and/or data), or you could use a structure/data comparison tool like Red-Gate SQL Compare and Red-Gate SQL Data Compare to compare two databases. With Red-Gate's tools, you can also compare a live 2008 database against a 2008 R2 backup file and move data between them.

We can generate scripts and we run them in lower version. steps to do this.

STEP 1: Right click database which you want to downgrade.you will see option to script that. in advanced section choose for which version you want to downgrade.

STEP 2: This will script your databse.

STEP 3: Copy the script on other machine and run following command.

SQLCMD -S LOCALHOST -d <databse_name> -i <scriptpath/name> –E

This link might help you more.