Downgrade from 2008R2 to 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Downgrade from 2008R2 to 2008

Downgrade from 2008R2 to 2008

Rate Topic

Display Mode

Topic Options

Author

Message

anthony.green

Posted Tuesday, September 04, 2012 2:57 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Hi All

Having an issue when downgrading from 2008R2 to 2008.

Using the copy database wizard to perform the copy works well for all bar 4 databases. The reason, all stored procedures, functions, etc etc are all encrypted so the CDW cannot read the definition to be able to recreate the objects on the other side.

Is there a way to easily decrypt all objects in a DB or a way to get the DB's over from R2 to 2008 without having to go in on the DAC.

Thanks

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1353771

EdVassie

Posted Wednesday, September 05, 2012 3:02 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:26 AM
Points: 2,621, Visits: 2,759

To decrypt your 'encrypted' SPs and views, google 'sql server decrypt stored procedure' and take your pick.

You might want to challenge why the daatbase objects are encrypted. It offers next to no protection over finding out what the source text is. Its main function seems to be to make database maintenance operations more complex than they need to be.

You may also want to challenge why the target system needs to be SQL 2008, and get a justification why it cannot be upgraded to SQL 2008 R2 to match the source system. All the extra work you are having to do is costing your organisation, and a good way to eliminate these costs is to get the SQL versions matching.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.

Post #1354389

anthony.green

Posted Wednesday, September 05, 2012 3:07 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Thanks Ed, this is a Dev server which was upgraded to R2 for a reason which no one knows, so to get Dev / Test / Live all in sync we are downgrading Dev to 2008 as everything else in the organisation is 2008.

The DB's in question are the aspdotnetstorefront databases and they are provided to you in the scipts as encrypted, the person who put the DB's in has now left and no one remembers the password to login and get the scripts so that they can be recreated without the encryption clause.

Post #1354390

Lowell

Posted Wednesday, September 05, 2012 5:31 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 11,642, Visits: 27,729

Anthony I've seen executables that decrypt without having to go into the DAC, but When I did the research once before, they seemed to be crippleware to try and get money from you.

I participated in a different thread that did require the DAC to get in, and put some screenshots there, and the link to the Decryptor procedure in this thread:
http://www.sqlservercentral.com/Forums/Topic1238608-100-1.aspx

not sure if that helps, though, since you wanted to avoid the DAC.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1354442

anthony.green

Posted Wednesday, September 05, 2012 5:46 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Thanks Lowell, tried them procedures but they fail with an error, cant remember which, will try again and post.

Want to try and avoide DAC as it kicks everyone out and we are on a but of a tight schedule to get a piece of work out the door so cant impare the developers at the moment.

As all environments share the same schema, for now I have just backed up and restored test onto dev for the DB's in question and used the import export wizard to create a extract package to pump the data from R2 to R1.

If there are problems with the above looks like I will have to put in a few late nights using DAC to script out the objects.

Post #1354449

Lowell

Posted Wednesday, September 05, 2012 5:53 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 11,642, Visits: 27,729

ok just downloaded this freeware :
http://download.cnet.com/Optillect-SQL-Decryptor/3000-10254_4-75300271.html

i installed it and it decrypts perfectly, without needing the DAC.

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1354452

« Prev Topic | Next Topic »

Permissions