Is there a quick and dirty way of defining a MS-SQL database and loading it with data from subfiles ?

[Michel Adam]

Seeking the list’s wisdom:

I have an application already ported from MPE to Windows. The data is in Eloquence and DBISAM files.

Given that there is an existing dictionary that describes everything, is there a quick and dirty way of defining an equivalent MS SQL Server database and loading it from the Eloquence/DBISAM data source?

If I could “generate” the SQL tables matching sufficiently their descriptions from the existing dictionary, QTP should be able to handle the rest, without having to resort to converting subfiles to CSV format (which CAN be crudely imported into MS-SQL…)

Any suggestions?

Thanks

Jean-Michel Adam, MSc. ISM
Database Architect / Systems Analyst
Informatics Shared Service Center, ENR & ITI and Lands
Government of the NWT
PO Box 1320 | Yellowknife NT | X1A 2L9
(867)767-9186 x 24148| Fax: (867)765-0144
www.iti.gov.nt.ca | www.enr.gov.nt.ca | www.lands.gov.nt.ca<http://www.lands.gov.nt.ca/> | www.geomatics.gov.nt.ca<http://www.geomatics.gov.nt.ca/>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20171019/eb857593/attachment.html>