Java program to get data from .bak file from management softwares like Deltek /Axium
posted 2 years ago
I am not able to find a solution online for this problem.I am trying this for past 1 week but no luck whatsoever. I have .bak file of Deltek Ajera (I believe this is .bak file of MS SQL because I searched and found that Ajera is based on MS SQL).
What I want is somehow the tables of entire database in a xls/csv file and I want all this process automated by some java program.I am not sure if that is possible or not since all I have is .bak file.So may be first I need to restore .bak file manually via SQL server 2008 management studio or something like that (no experience in this regard).Please let me know if my question make sense.I somehow want this bak file to be imported in My SQL(if possible) because I have experience in working with it such as MySQL Workbench where we can import/export from GUI etc.