ibdac migration wizzard useless?

[kiwisigi]

Hi,

Just got ibdac last week and wanted to migrate a program from ibx. I notice 2 really basic omissions e.g. errors in that migration program. (delphi x8, fb1.5)

1) does not change TibStringField to TStringfield???

2) and worse - it deletes parameters for stored procs. When I get them added again then they have a different order e.g. input before output (ibx has output before input)

I have about 80 stored procs which I use in the code quite often setting params by "number" as this should be faster than by name (or not?)

For me this tool is basically useless and should NOT be offered to any customers I guess..
Or did I overlooks something and there is a workaround for it to work properly?

Could I change the tool to work for me (and others) ?

Any pointers are appreciated..

thanks
sigi

[ViktorV]

Migration Wizard serves only to simplify routine operations, and now doesn't support TIBStringField on TStringfield and transfer of TIBStoredProc parameters to TIBCStoredProc.
The order of TIBCStoredProc parameter auto-generation is default behavior of our components used by many our users - so we won't change it.

[kiwisigi]

Hi Victor,

I was not asking you to change the order of the default parameters.
I was asking you why the parameters get "LOST" with the migration wizzard and why the tibstringfield fields cannot be changed to tstringfield.
This creates DAYS of work for each program where one uses lots of stored procs.

I have lots of programs to migrate and so might others who consider your components.
To fix the migration program to cater for these 2 issues to me seems a small job and I was almost offering to volunteer to do so - or has somebody else solved this issues already and there is a way around this?

The answer you gave does not address any of the problems mentioned and is NOT of any help to us customers unfortunately....

have fun
sigi

[ViktorV]

1. To replace TIBStringField with TStringfield, you can perform global search through your *.dfm files- and replace all TIBStringField with TStringfield.
2. Due to the difference between TIBStoredProc and TIBCStoredProc our Migration Wizard has no support for transfer of TIBStoredProc parameters to TIBCStoredProc.

[kiwisigi]

Hi Victor,

Your response is not helpful. I was asking why you drop the parameter record from the dfm file for stored procedures e.g. if there was a specific reason. The vcl name gets changed so some changes are done to the stored procs.
If you can't or don't want to answer in a meaningful manner that's fine with me. I will not waste any more time on this.

cheers
sigi

[ViktorV]

If you translate parameters from TIBStoredProc to TIBСStoredProc in the same order, they won't work. You can make this sure by creating them manually in TIBСStoredProc. Therefore our Migration Wizard has no support for translation of TIBStoredProc parameters to TIBCStoredProc.