Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Jun 25 '12 at 14:59

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer 1

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.

share|improve this answer
    
I just want to make indexes. Is that somehow connected to CPU? –  udar_molota Jun 18 '12 at 17:06
    
Absolutely, if your dev machine has 4 CPUs it may consider one plan shape that is not optimal on your production machine that has 1 or 2 CPUs (or 16), and derive index suggestions off that choice. You probably won't see too much difference but it is something to be aware of. –  Aaron Bertrand Jun 18 '12 at 17:20
    
On my website I have poor conditions, even maybe my home machine is stronger. My question is there some differences between backup versions that I couldn't restore it back on Express. Some stucture changes maybe... –  udar_molota Jun 18 '12 at 17:27
    
If the version on your web site is newer (2008 R2, for example), then no you won't be able to restore it to your local copy of, say, 2005 or 2008. The version of the instance you're restoring to has to be >= the version of the instance from which the backup came. –  Aaron Bertrand Jun 18 '12 at 17:28
    
Both 2008 versions –  udar_molota Jun 19 '12 at 11:24
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.