Solved

D3 Data Dictionary Problem

Posted on 1998-06-15
4
153 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

717 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