I want to use DTA, but on my website I have an Express Server version.
Can I backup my DB on Express server, restore it on my personal computer with Enterprise Version, make some tuning by DTA and then restore it back on webserver Express MS SQL? Are they compatible? Both MS SQL 2008 R2, but one is Express and second not.
Sql-server – MS SQL 2008 Express – Database Tuning Advisor
database-tuning-advisorsql serversql-server-2008
Related Question
- Sql-server – Recreate MSDB for SQL Server Express 2008
- Sql-server – Attach database from SQL Express 2008 Edition to SQL Server 2008 Enterprise Edition
- Sql-server – Upgrade SQL Server 2008 Express to SQL Server Workgroup 2008 Volume License
- Sql-server – Trying to install SQL Server 2008 Management Studio Express
- Sql-server – Restore DB from SQL Server 2008 R2 to 2014 Express
- SQL Server – Views Created by Database Tuning Advisor
- SQL Server 2017 – Database Tuning Advisor CLI ‘dta’ Missing
Best Answer
As long as you don't enable any features that aren't supported on Express Edition, you should be fine. For example I think you can use DTA to recommend table partitioning which obviously won't work on Express edition. The other thing to think about is that the server running Enterprise Edition might have a lot more memory or CPUs, so the optimizer on that server might make much different plan choices than it will on your web server.