Article View: borland.public.vdbase.data.sql
Article #1188Re: Data Migration Wizard Sucks
From: Karsten Tinzmann - Promex South ...
Date: Thu, 02 Apr 1998 00:00
Date: Thu, 02 Apr 1998 00:00
41 lines
2281 bytes
2281 bytes
Yes, a friend of mine has one (not that I agree) : Dumb Vdb and get Visual FoxPro. Please note: this is not my solution! With all the problems I am experiencing with VdB 7.0 I am considering this move although I have purchased VdB 7.0 in mid January 1998 (for a price equal or more than what many poeple earn here a month) and have tried to download the patch 7.01 about a dozen times, I have not achieved it yet as the Borland Server stops responding between the time I have downloaded 1Mb and 4 Mb. I have contact Borland here and they have said that they will assist me. I had the same problem, but solved it by importing the files first into Quatro Pro with ODBC by means of the QuickColumn menuitem under the Datamenu. Then I saved the files as dbf files and opened them with VdB 7.0 in the Tabledesigner and changed all numeric fields to float where I set the decimal to one larger than the longest decimal. It worked. If your data files are to long to be imported as a whole into Quattro Pro, then use ODBC to select data and import the table in bits and pieces. Once you have configured all the tables to dbf tables, append the first table with the other tables (search the helpindex for append() ) Karsten Dave Waller wrote in message <34F1DC4D.EEC@Isaac0.inwave.com>... >I am having real trouble with the Data Migration Wizard supplied with >DB7.0. > >I have 15 odd tables that have various data types in them (like >normal), >and when I go to move the to InterBase with the "data mig wiz" I loose >the decimal parts and it puts the number into a double w/o a decimal. > >If I change the feild type manualy I get a severe GPF and a reboot soon >follows. > >Does any one have a fix for this? > >Dave Waller
Technical Details
Message-ID:
<6g0jsj$ab619@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<34F1DC4D.EEC@Isaac0.inwave.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,99688b2e2b0ee81a X-Google-Attributes: gidff5a1,public From: "Karsten Tinzmann - Promex South Africa" <promexkt@icon.co.za> Subject: Re: Data Migration Wizard Sucks Date: 1998/04/02 Message-ID: <6g0jsj$ab619@forums.borland.com> X-Deja-AN: 340255819 References: <34F1DC4D.EEC@Isaac0.inwave.com> X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Organization: Another Netscape Collabra Server User Newsgroups: borland.public.vdbase.data.sql