Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Import QVD file to dynamic SQL table based on field types

Import QVD file to dynamic SQL table based on field types 4 months 2 days ago #19243

  • vgupte
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 1
Hi,
I am using Visual Importer Enterprise. I can easily import a QVD file to an SQL table which has already been created.

I am looking for a way by which I can import all fields of QVD file to an SQL table dynamically i.e. drop the existing table and re-create it based on QVD field types. I understand I can use the PRE SQL to drop and create table. But to create the table, how do I access the QVD file's field names and types ?

Regards,
Vik

Please Log in or Create an account to join the conversation.

Import QVD file to dynamic SQL table based on field types 4 months 2 days ago #19245

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7646
  • Karma: 33
  • Thank you received: 427
The table must be created by the user, Our software will not create it for you automatically.
We can have very long argument how it would be fantastic to have such feature,
However most likely it will create tables with incorrect datatypes so the user would need to recreate it anyway .
Our software can help you to create table. see the screenshot.
Mike
Attachments:

Please Log in or Create an account to join the conversation.

Import QVD file to dynamic SQL table based on field types 4 months 2 days ago #19248

  • vgupte
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 1
ok. But is there a way to read a QVD file's meta data like field names and type ?

Please Log in or Create an account to join the conversation.

Import QVD file to dynamic SQL table based on field types 4 months 1 day ago #19249

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7646
  • Karma: 33
  • Thank you received: 427
You may see approximate fields type using Q-Eye
www.etl-tools.com/q-eye/overview.html
It extracts the metadata from QVD XML header
You will not be able to see the size for fields
EG: is it char(10) or char (1000)?
I am afraid this is how data in QVD files is stored.

Mike
Attachments:

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 169 guests and no members online