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

[Bob Deskin]

Try QSHOW. 

> SET LANGUAGE SQL
> GENERATE DATABASE ALL

Bob
> On Oct 19, 2017, at 1:37 PM, Michel Adam <Michel_Adam at gov.nt.ca> wrote:
> 
> 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 <x-msg://2/www.iti.gov.nt.ca> | www.enr.gov.nt.ca <x-msg://2/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/>
>  
>  
> -- 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com <mailto:powerh-l at lists.sowder.com>
> Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com <mailto:powerh-l-request at lists.sowder.com>
> Unsubscribe: 'unsubscribe <password>' in message body to powerh-l-request at lists.sowder.com <mailto:powerh-l-request at lists.sowder.com>
> http://lists.sowder.com/mailman/listinfo/powerh-l <http://lists.sowder.com/mailman/listinfo/powerh-l>
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com <http://lists.sowder.com/> powerh-l' to your search terms to search the list archive at Google.

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