Multiple QVD files Convert to SQL Server Database

[katetsan]

Hi Experts,

I'm wondering whether there is any way to convert multiple qvd files to SQL server database?

Thanks in advanced

[Anil_Babu_Samineni]

The ways are following as i am having

1) Need to open QVD in text editor and then copy paste in SQL server table (Best way)

2) If you can save after open the QVD's, You need to store it as XLS / CSV format and then need to import while configurator

3) If above won't help, please describe more

[tomasz_tru]

You can do it directly from the script using "SQL INSERT INTO..." in a loop that pass table row by row.

Tomasz

[Peter_Cammaert]

A third option may be to check the original data sources of the QVDs. There may be a shortcut to import data from the original data sources into SQL Server tables by way of the Integration Services component or even the Import/Export feature in SQL Server Management Studio. Keep in mind that using a QVW document (the only tool to extract data from usually very large QVDs) to transfer data to an RDBMS may be extremely slow and as a result take an awful lot of time.

Peter

[katetsan]

Hi Peter,

Thanks for your reminder. I do have the same concern as you mentioned.

I'm quite interested in "Integration Service" component as you mentioned, is that provided by Microsoft SQL server?

Thanks a lot

[Peter_Cammaert]

Indeed, it's a SQL Server package that can be used to integrate and transform data streams/source in a SQL Server DBMS environment. Search for 'SQL Server Integration Services' and you'll find a lot of information.

Do not use it if it doesn't offer prebuilt solutions for your situation, or a quick path towards data integration for you sources. It's a complex product and the learning curve may be too steep for a one-off project. There are other ETL tools available for SQL Server as well.