At 10:48 AM 9/4/01 +0100, Alastair Burr wrote:
>Nevertheless, mine is no monster database, but is ODBC a
>better way to convert my data from Dos to Windows? As you
>can see from the above, Brent has given me a solution to
>the import problem and JM has offered a solution to the
>character conversion problem if I can't resolve it myself,
>but if the ASCII-ANSI conversion was done by ODBC it could
>save me a lot of time.
Alastair,
The ODBC option is the painless process to migrate data.
You don't have to worry about UNLOAD, LOAD or COMPUTED
COLUMNS, etc.
If your databases (old and new) are ODBC compliant, i.e:
QUOTES '
PLUS +
SINGLE _
MANY %
IDQUOTES `
Then, all you have to do is the following:
01. Create a System DSN for old database (such as OldDB)
(using the ODBC Data Sources (32bit) Administrator)
R:BASE 2000 (version 6.5++) for Windows ODBC Driver:
Name: R:BASE Database Driver (*.RB1)
Version: 6.50.00.03
Date: 06-15-2001
02. CONNECT NewDB
03. SCONNECT OldDB IDENTIFIED BY NONE
(if there is no owner password, etc).
04. SATTACH TableName1 AS tTableName1 USING ALL
SATTACH TableName2 AS tTableName2 USING ALL
SATTACH TableName3 AS tTableName3 USING ALL
SATTACH TableName4 AS tTableName4 USING ALL
SATTACH TableName5 AS tTableName5 USING ALL
05. SET ERROR MESSAGE 2059 OFF
DELETE ROWS FROM TableName1
APPEND tTableName1 TO TableName1
DELETE ROWS FROM TableName2
APPEND tTableName2 TO TableName2
DELETE ROWS FROM TableName3
APPEND tTableName3 TO TableName3
DELETE ROWS FROM TableName4
APPEND tTableName4 TO TableName4
DELETE ROWS FROM TableName5
APPEND tTableName5 TO TableName5
SET ERROR MESSAGE 2059 ON
06. SDETACH ALL
SDISC OldDB
There you have it ... Seamless data migration!
I do recommend to RELOAD database!
>... now it's so damn quick I never seem to get time to
>go and make one! With Brent's solution, those 30-odd
>thousand rows were loaded before I hardly had time to
>take my hand off the mouse! With TBREAK set on perhaps
>R:Base could do some database maintenance, or chat about
>the weather or something while taking its time for a few
>minutes!!
See ... what you were missing!
>Well, you do keep saying "if you can dream it..." <g>.
Absolutely!
But ... you must dare to dream!
Very Best Regards,
Razzak.
===================================-============================
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
