Solved

D3 Data Dictionary Problem

Posted on 1998-06-15
4
146 Views
Last Modified: 2010-04-04
I'm trying to use the Data Dictionary to handle contraints.
 (I'm porting my 2-tier apps to 3-tier)
 I can't seem to import at table level!
 I can import the whole database but since I have hundreds of tables
 and I only intend to use a few, it would be a waste of space.
 Not to mention it took a very long time.

 Also, I'm trying to place the data dictionary inside the
 Informix Database. It is currently in Paradox.

 What happens is that after importing the table to Informix using
 the Database Migration Wizard and registering it as a Dictionary
 in the Database explorer, when I try to open it,
 the database explorer shuts down!
 Yes, without even saying goodbye!!!

 Any help would be greatly appreciated.

 Zandy
0
Comment
Question by:zandy
  • 2
4 Comments
 
LVL 5

Expert Comment

by:ronit051397
ID: 1352883
Hi again,
I am not familiar with this issue, but I can direct you to the following addresses, maybe you'll find some information in there:
http://developers.href.com/THREAD::waThread.29.23712
http://developers.href.com/THREAD::waThread.29.115795
http://developers.href.com/THREAD::waThread.29.115795

Ronit
0
 

Author Comment

by:zandy
ID: 1352884
Thanks for the Info.
It was very helpful.

It answered a lot of other questions for me regarding the data dictionary.
But still it's not what I'm looking for.

You know this site is really cool !!!

Zandy
0
 
LVL 3

Accepted Solution

by:
altena earned 200 total points
ID: 1352885
I always do this the "at first sight" hard way:

1. Write a small tool to "reverse engineer" the tables in DB-1
   (create a "create table..." string)

2. use these create table scripts to generate the new tables
   in the new DB

note: Usually you want to tune these scripts to optimise for the new db.

3. Write a small tool to pump the records from one DB into
   the next.

And you will be finfished. This takes some effort the first time, after that its peanuts.

 Good luck.
0
 

Author Comment

by:zandy
ID: 1352886
I've tested with another SQL Server (Interbase)
and everything went fine.

I suspect it is a bug in the Informix SQL Link Driver.
Hope they'll fix it in D4!

Thanks again,
Zandy
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delphi XE10, DigitalPersona Fingerprint reader and MySQL 6 214
Path  to current project in Delphi. 2 71
find a node in VST 2 62
Performance of SQL statement 37 95
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now