Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How migrate DBF-tables from Novell to Linux

2 posts in Linux Last posting was on 2008-12-10 15:11:51.0Z
Alexander Busam Posted on 2008-12-10 08:53:26.0Z
Date: Wed, 10 Dec 2008 09:53:26 +0100
From: Alexander Busam <a.busam@hofmann-foerdertechnik.com>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
Newsgroups: Advantage.Linux
Subject: How migrate DBF-tables from Novell to Linux
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 195.145.2.90
Message-ID: <493f81cf@solutions.advantagedatabase.com>
X-Trace: 10 Dec 2008 01:46:07 -0700, 195.145.2.90
Lines: 22
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.145.2.90
Xref: solutions.advantagedatabase.com Advantage.Linux:1187
Article PK: 1131011

Hello,

I want migrate a database from Novell to Linux. Therefore I copy all
files (dictionary-, tables- and index-files) from one server to another.

At the Linux-server I changed the dbf- and dbt-filename to lowercase.

Additional I have to delete and add the renamed table.


Is there a script available to change all the dbf- and dbt-filenames to
lowercase?

How can I change the tablenames in the dictionary without adding all the
dbf-tables and their index-files by hand in the Advantage Data
Architect ?

Thanks a lot.

Best regards,

Alex


Edgar Sherman Posted on 2008-12-10 15:11:51.0Z
Date: Wed, 10 Dec 2008 08:11:51 -0700
From: Edgar Sherman <no@email.com>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
Newsgroups: Advantage.Linux
Subject: Re: How migrate DBF-tables from Novell to Linux
References: <493f81cf@solutions.advantagedatabase.com>
In-Reply-To: <493f81cf@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.24.34.164
Message-ID: <493fdaa6@solutions.advantagedatabase.com>
X-Trace: 10 Dec 2008 08:05:10 -0700, 10.24.34.164
Lines: 40
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.164
Xref: solutions.advantagedatabase.com Advantage.Linux:1188
Article PK: 1131012

You should not need to make any modifications to the dictionary
meta-data (i.e. no reason to remove/re-add the tables to the dictionary).

All you should need to do is set LOWERCASE_ALL_PATHS=1 in the ads.conf
(and restart ADS). Then rename the files to all lower case (also be
sure the directory path is lowercase).

The help file suggests the following command should work to lowercase
your files. Be sure to have a backup copy of your data just in case.

find -type f | while read i; do j="`echo $i | tr [[:upper:]]
[[:lower:]]`"; [ "$j" != "$i" ] && { mv "$i" "$j" || echo "ERROR: $i"; }
; done

http://devzone.advantagedatabase.com/dz/webhelp/Advantage9.1/advantage.htm#advantage_concepts/advantage_linux_development_notes/linux_case_sensitivity.htm

Edgar

Alexander Busam wrote:
> Hello,
>
> I want migrate a database from Novell to Linux. Therefore I copy all
> files (dictionary-, tables- and index-files) from one server to another.
>
> At the Linux-server I changed the dbf- and dbt-filename to lowercase.
>
> Additional I have to delete and add the renamed table.
>
>
> Is there a script available to change all the dbf- and dbt-filenames to
> lowercase?
>
> How can I change the tablenames in the dictionary without adding all the
> dbf-tables and their index-files by hand in the Advantage Data Architect ?
>
> Thanks a lot.
>
> Best regards,
>
> Alex