Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Downgrade from 2008R2 to 2008 Expand / Collapse
Author
Message
Posted Tuesday, September 4, 2012 2:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:20 AM
Points: 5,218, Visits: 5,067
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
Posted Wednesday, September 5, 2012 3:02 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:18 AM
Points: 2,869, Visits: 3,210
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.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,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
Posted Wednesday, September 5, 2012 3:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:20 AM
Points: 5,218, Visits: 5,067
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.





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 #1354390
Posted Wednesday, September 5, 2012 5:31 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:24 PM
Points: 12,906, Visits: 31,984
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
Posted Wednesday, September 5, 2012 5:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:20 AM
Points: 5,218, Visits: 5,067
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.





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 #1354449
Posted Wednesday, September 5, 2012 5:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:24 PM
Points: 12,906, Visits: 31,984
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 »

Add to briefcase

Permissions Expand / Collapse