Ovi
Reputation: 2750
sql server 2008 r2 database downgrade
Is there a way to downgrade a database, that has been created on SQL Server 2008 R2, to work on an older version of SQL Server 2008 (RTM/SP1).
Upvotes: 1
Views: 1126
Answers (1)
Remus Rusanu
Reputation: 294207
No. There is no way to downgrade a database once it was upgraded. You can only extract all the tables and all the data and import them into an RTM/SP1 database.
Upvotes: 6
Related Questions
- Move SQL Server database from new version to old version
- Migrate a SQL Server database to a lower version
- SQL Server 2008 R2
- Downgrade SQL Server 2008 r2 to SQL Server 2008
- Downgrading SQL server 2008 to SQL Server 2005
- SQL Server 2008 to SQL Server 2005
- How do I downgrade a SQL 2008 MDF file for use in SQL 2005?
- upgrading from sql server 2008 to sql server 2008 R2
- Upgrading from SQL Server 2005 to SQL Server 2008
- Upgrade the database to SQL server 2008