Hello TechKnow members and visitors!
I've been challanged to move a application from one server to another.
So this application just uses a SQL database and a few program files, nothing out of the ordinary.
However, once all the files and database have been moved, the application complained the stored procedures were missing.
I went back to the original server to discover that these are stored with encryption, this has been done highly likely by the software supplier to protect their product. All fine, but this company is hard to reach and I was unable to get support, time for another look at the situation...
As you know, there are plenty ways to export/import databases in SQL, I followed these steps in order to move the encrypted stored procedures:
1. Perform a SQL to SQL migration (this step might be unneeded, but could be since all required permissions and file locations are set)
2. Take the database instance offline
3. Get the original databases (MDF and LDF), copy them to the new server
4. Rename the database, DBNAME.MDF to DBNAME_Data.MDF, the LDF was fine
5. Start the database instance
That's really all! I've tried tricks using import/export and manual dumping, all failed, but this did the trick and the application works fine now.