Subject Re: [firebird-support] Automate transfer data from one database structure to another
Author Namit Nathwani
Hi Martijn

At 03:51 pm 13/05/2005, you wrote:
>Ah, so you don't want to transfer data alone, but it should also update
>existing structures?

Let's have it the other way round. I have an empty database with all new
stuff in it. I just want to get data from same named tables in an older
table into the matching tables <g>, if a field is not found forget it's
data and a new one is found let it stay empty.

>Hmmm - let me tell you, it just ain't that easy... :-)
>
>1) keep a version number if your database
>
>2) create an "update" application that includes scripts to update your
>database
>from one version to another
>
>3) run the update app, check version number, run scripts.

No this above ain't easy <g>



Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://ahmedabad.sancharnet.in/vso_ad1/
namitbn@...
___________________________________________


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.9 - Release Date: 12/05/2005