Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two app's one is my Dash the other was to create a QVD which would feed several other app's.
the App that creates the QVD has been removed. How do I extract the Script from the QVD to replicate the process of creating it?
Unfortunately there's no way to recover qvd creation script from qvd. Best practice is to perform a backup activity once in a while to avoid such scenarios.
Best Regards,
Aditya
But the QVD holds the script that it's created from?
The qvd doesn't store the script which has created it. You may open the qvd with an editor like Notepad++ and maybe looking to the lineage-part to get a few hints and information (it's for example depending on if lineage was enabled and from which source the data was created) but there won't be a full load-script.
Did you look for any backup-files (regular from the IT, own ones, windows shadow copies or other snapshot tools, ...)?
- Marcus
A QVD is usually created by a statement along the lines of:
Store * From SomeTable into SomeFile.qvd(qvd);
So even if this was saved into the QVD (and I believe it isn't), I doubt it'd help.
If the file creating the QVD was deleted, and you don't have a backup, I'd suggest checking for the reload log from the file in question, as that would have the script in it. If that's gone too, and there are no backups of either, I think you're out of luck.
So even though the QVD file holds
NoConcatenate LOAD
DocNo,
Line,
NonGlass,
Composite,
Qty,
BIItem,
NettArea,
Width,
Height,
sp,
sp2,
Sp3_,
LinePrice,
G1,
G2,
G3,
G4_,
Perim,
Area,
Description
;SQL SELECT Line,
NonGlass,
Composite,
Qty,
BIItem,
DocNo,
NettArea,
Width,
Height,
sp,
LinePrice,
sp2,
G1,
Sp3_,
G2,
G3,
G4_,
Perim,
Area,
Description
FROM G.dbo.GOLines</Statement>
</LineageInfo>
<LineageInfo>
<Discriminator>{Azure_SQL_Database G};</Discriminator>
<Statement>Gelmap:
I can't take this from the file a put it into a new app?
That's already a good starting point to re-create the qvw and more as the most qvd's contain but it mustn't be the whole truth because there might be multiple other statements within the script which might have an impact, for example:
- Marcus
Just an addition to the suggestion from @Or. The document-log will contain most of the extra information which I mentioned above. Beside the qvw-application folder the document-log is also stored and backup within the task-area.
- Marcus