Solved

D3 Data Dictionary Problem

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 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

20 Experts available now in Live!

Get 1:1 Help Now