Solved

D3 Data Dictionary Problem

Posted on 1998-06-15
4
147 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 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