Import MSSQL database and reconstructing table relations

[Rene Simons]

Hi,

I am about to import a huge MSSQL database into a dictionary.
Is there anyone who has experience on how to convert the MSSQL table dependencies into dct table relations without having to type a lot?

Cheers,
Rene

[rjmiller]

I have done so with small app I have created with NT 6.14.  The dependencies came correctly using the sync feature of dictionary editor in CW 8.0.8778 but it looks like there may be issues with TN 6.14 with regards to file relationships and lookups.  1 to Many relationships are identified by NT 6.14 as having links back to parent even when they do not.  This can be fixed by removal of parent tab in child update procedure but even then I have not been able to get multiple lookups to work properly in MSSQ although it does seem to work with TPS files.

I have posted regarding this and sent a couple of small test apps/dcts but have not yet heard from Bruce.

Look at the attached zip and try the apps/dcts before you go to a lot of trouble.  One of the apps is an appwizarded app from CW8 and other is a wizarded webserver app from NT6.14.  Both used the included dct.



[attachment deleted by admin]

[Rene Simons]

Hi,

Thanks for your reply.
Yes, it is as simple as you describe.
I imported the database structure into the DCT.
There were "only" 357 tables there and their relations.
It took some time to complete but I'm a happy acmer now.

I used the application wizzard for the new app but dared not to generate the Browses and Forms.
I'll do the required ones by hand.

Cheers,
Rene

[Bruce]

<cluck cluck cluck>...

[Rene Simons]

Yup!