I have a quick simple question: can a SQL Server 2008 R2 Enterprise/ Developer edition
backup be restored in a SQL Server 2008 R2 Express
version?
Source: SQL Server 2008 R2
10.50.1600.1 RTM Developer Edition (64-bit)
Destination: SQL Server 2008 R2 Express 64bit (I just download setup right now, so don't know about other details.)
Also what feature will effect if we migrate from Enterprise or Developer edition to Express version
like we used
- FTS(Full-Test search)
- Reporting services
- SSRS
- SSIS
- SQL job for auto backup etc.
First of all, there is no SQL Server Ultimate edition - we have Express, Web, Standard, Enterprise, Developer and that's about it. Your source server is a Developer edition.
But yes - as long as the destination's version (2008 R2) is identical (or newer), you can restore a backup from a source server (here also 2008 R2).
You just can never go back in time - your backup from 2008 R2 cannot be restored on 2008 or 2005 (or even older ones)
Update:
See here on MSDN for a detailed matrix of which features are included in which editions