Need help restore a database

Question

Question

Tam Nguyen · Aug 27

Hi,

I have a Cache backup file in .cbk format that were backup in 2017. The application has since be decommissioned. Management now would like to extract the data from this database. Any in your expertise is greatly appreciated. I am in IT and have SQL Server guy. I don't know anything about InterSystems Cache Database system.

Thanks very much for all your help

Regards,

tamthnguyen@gmail.com

Discussion (4)2

Log in or sign up to continue

score 0 · Answer 1 · 2024-08-27T14:05:44-04:00

I would imagine if you have a license from Intersystems you could install Cache, mount the DB, and then the next question is "Was the application developed back in 2017" with an SQL interface, ie are there SQL tables that exist for the database that you have?" If so you could connect to the db via ODBC and extract the data.

If not then that's a much large endeavor as you would need to have the tables defined and depending on how much meta-data/documentation you have for the data that could be quite involved.

score 0 · Answer 2 · 2024-08-27T15:11:09-04:00

TThanks very much Stephen for your response. Unfortunately, the install DVD is lost somewhere. I don't have anything left of the old system aside from the backup file. Is there anyway I can download the Intersystem Cache and attempt to mount the data. But the file is a backup. Don't I have to restore it first? .. :) Sorry I am new to all this.. Thanks for your help

score 0 · Answer 3 · 2024-08-27T15:29:45-04:00

Hi .. I actually found the license key. Apparently, we are licensed for Cache 5.1. Can someone send me a link to download Cache. Greatly appreciated.

Thanks

score 0 · Answer 4 · 2024-08-28T01:31:13-04:00

Timo Lindenschmid · Aug 28

Hi Tam,

please contact WRC they can assist with your request.

Best Regards

Timo

0 0