Link to home
Start Free TrialLog in
Avatar of apollo7
apollo7Flag for United States of America

asked on

Refresh Dev server with Production database

I am refreshing a CRM 2011 Dev server with the database from our Production server.

I have done this process hundreds of times (just not at my current client).

They insist that I downgrade the database to Standard Edition (on the Dev. database server) from Enterprise Edition (Production database server).

They have detailed instructions on this and a DDL query to downgrade the EE database to SE.

I have never done this and would like to know if anyone else follows this process.
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

what is the sql server they use?
 sql 2012?

if "downgrade" means sql server downgrade from enterprise to standard
it can be done via Uninstall of SQL Server
do they really want it?
---

if just DB that has EE "functionalities"
just follow their detailed instructions on this and a DDL query to downgrade the EE database to SE.
Just make sure to backup DB before you start ( just in case)


more:

Downgrade from SQL Server Enterprise Edition to Standard Edition
https://www.mssqltips.com/sqlservertip/3079/downgrade-from-sql-server-enterprise-edition-to-standard-edition/
Avatar of apollo7

ASKER

It is because there are functionalities in EE (Production Server) that they don't have in SE (Dev Server).

I have not made any changes after the import of the new org and it seems to be working fine, is there any reason the DDL query method needs to be done.

They have in their documentation (from a past tech) that: CRM databases created in SQL Server EE include a partition to that segregates audit records.  This partition must be removed before the database can be deployed onto a SQL Server running Standard Edition.

Have not seen this before, does this matter?

I can run the query if it could help.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of apollo7

ASKER

Thanks, sounds like good advice.
Very interesting.  One of the big advantages of Enterprise is being able to compress data.  Does compressed data actually restore to standard edition?  Or do you just not compress data in Prod, giving up on one of the biggest performance pluses to keep it compatible with standard edition?
Avatar of apollo7

ASKER

I think it is simply a matter of cost.  The production server was built with EE and the Dev server is a VM that was built with SE to be used to test plugins, deployment packages, etc
I get the reasoning, for sure.  Enterprise is $$$$$$.

But, I'm curious, do you have some way to remove data compression to restore it to standard, or do you just not use data compression at all?
if $$ are the problem -- and in case there are 3-4 developers need to use it

get DEV edition  (~$75) x4 people or via MSDN subs if they have

DEV <=> Enterprise functionalities