SDAC to UNIDAC properties/methods mapping

brace · Post by **brace** » Wed 30 Jun 2010 17:18

Is there a document where I can see all the properties / methods that are "lost" in passing from SDAC to UNIDAC.

CursorUpdate is one of them, but is there a place where i can see them all?

Thanks.

Dimon · Post by **Dimon** » Thu 01 Jul 2010 09:55

Use the SpecificOptions property to provide extended settings for each data provider. SpecificOptions can be setup both at design time and run time.
You can set CursorUpdate as a specific option.

brace · Post by **brace** » Thu 01 Jul 2010 10:21

But the UNIDAC migration wizard doesn't handle specific options?

I made a test migration of a datamodule where I was using 3 times CursorUpdate, but the migration wizard ignored them, is this the normal behaviour?

Dimon · Post by **Dimon** » Thu 01 Jul 2010 12:22

Thank you for information. We have reproduced the problem with migration wizard and fixed it. This fix will be included in the next UniDAC build.

brace · Post by **brace** » Thu 01 Jul 2010 13:55

I am using unidac to migrate from SQL Server to Postgresql, then I will use unidac for postgresql only.

What do you suggest for this? I somehow probably need to take a decision for all the specific properties I am using. The migration wizard doesn't allow something like this?

Dimon · Post by **Dimon** » Thu 01 Jul 2010 14:42

SQL Server and PostgreSQL have different specific options, therefore you can't use migration wizard for such options. You should replace these options manually when PostgreSQL has similar properties.

brace · Post by **brace** » Thu 01 Jul 2010 17:11

ok but it would be great that the migration tells me once moving from SDAC to unidac which are the specific options, may be in the log file.

like

MyDatamodule.pas

MSQuery1 is using SpecificOption CursorUpdate

etc...

Dimon · Post by **Dimon** » Fri 02 Jul 2010 07:34

Thank you for your inquiry. We will investigate the possibility of adding this functionality in the future. As soon as we solve this question we will let you know.

brace · Post by **brace** » Fri 02 Jul 2010 15:56

On converting some files I have this error (SDAC to UNIDAC):

---------------------------
Error
---------------------------
Parser: The unknown symbol '
---------------------------
OK Details >>
---------------------------

Clicking on Details I have: (note the log doesn't contain any interesting info).

[08359165]{dac120.bpl } Crparser.TParser.InternalGetNext + $B7D
[5000AB16]{rtl120.bpl } System.@NewUnicodeString (Line 18113, "System.pas" + 7) + $0
[50009EA1]{rtl120.bpl } System.@UStrFromPWCharLen (Line 17078, "System.pas" + 28) + $0
[5000AB16]{rtl120.bpl } System.@NewUnicodeString (Line 18113, "System.pas" + 7) + $0
[083592EC]{dac120.bpl } Crparser.TParser.GetNext + $2C
(000075A3){unimigwizard120.dll} [08CB85A3]
(0000763C){unimigwizard120.dll} [08CB863C]
(0000787D){unimigwizard120.dll} [08CB887D]
(00006CB4){unimigwizard120.dll} [08CB7CB4]
(00006703){unimigwizard120.dll} [08CB7703]
(0000F990){unimigwizard120.dll} [08CC0990]
(0000FDED){unimigwizard120.dll} [08CC0DED]
[50057113]{rtl120.bpl } Classes.TBasicAction.Execute (Line 12221, "Classes.pas" + 3) + $7
[501E84B1]{vcl120.bpl } ActnList.TContainedAction.Execute (Line 448, "ActnList.pas" + 8) + $2C
[501E9294]{vcl120.bpl } ActnList.TCustomAction.Execute (Line 1094, "ActnList.pas" + 7) + $8
[50056FD7]{rtl120.bpl } Classes.TBasicActionLink.Execute (Line 12150, "Classes.pas" + 2) + $7
[211D9635]{vclactnband120.bpl} ActnMenus.TCustomActionMenuBar.ExecAction (Line 1064, "ActnMenus.pas" + 6) + $D
[211DAAEB]{vclactnband120.bpl} ActnMenus.TCustomActionMenuBar.TrackMenu (Line 1746, "ActnMenus.pas" + 15) + $15
[211DE044]{vclactnband120.bpl} ActnMenus.TCustomActionMainMenuBar.TrackMenu (Line 3472, "ActnMenus.pas" + 3) + $3
[211D91FD]{vclactnband120.bpl} ActnMenus.TCustomActionMenuBar.CMItemClicked (Line 943, "ActnMenus.pas" + 3) + $4
[501D0BFA]{vcl120.bpl } Controls.TControl.WndProc (Line 6640, "Controls.pas" + 91) + $6
[0E5DD520]{rbIDE1112.bpl} Ppsynuedit.TSynEditPlugin + $74
[501D5287]{vcl120.bpl } Controls.TWinControl.WndProc (Line 9334, "Controls.pas" + 136) + $6
[211DABDA]{vclactnband120.bpl} ActnMenus.TCustomActionMenuBar.WndProc (Line 1781, "ActnMenus.pas" + 25) + $4
[501D49A0]{vcl120.bpl } Controls.TWinControl.MainWndProc (Line 9063, "Controls.pas" + 3) + $6
[50057E04]{rtl120.bpl } Classes.StdWndProc (Line 12723, "Classes.pas" + 8) + $0
[501CB982]{vcl120.bpl } Controls.FindControl (Line 2997, "Controls.pas" + 6) + $9
[501F9EAB]{vcl120.bpl } Forms.TApplication.ProcessMessage (Line 9613, "Forms.pas" + 23) + $1
[501F9EEE]{vcl120.bpl } Forms.TApplication.HandleMessage (Line 9643, "Forms.pas" + 1) + $4
[501FA219]{vcl120.bpl } Forms.TApplication.Run (Line 9780, "Forms.pas" + 26) + $3
[004259D2]{bds.exe } bds.bds (Line 196, "" + 7) + $7

bork · Post by **bork** » Tue 06 Jul 2010 11:13

Hello

This error can occur if migration wizard cannot convert some form or unit. We want to help you but we need to get the form that cannot be converted. Try to determine which form cannot be converted and send it to us by E-mail. We will try to help as soon as we get this form. To determine which form cannot be converted try convert your form and units one by one.

brace · Post by **brace** » Tue 06 Jul 2010 15:07

ok I will send, but I am using manby third party components, anyway i imagine you can test anyway. Let me find the simplest form with the problem.

bork · Post by **bork** » Wed 07 Jul 2010 14:12

OK. The simplest form is easy to reproduce and fix such error. If you have possibility to send the simplest form it will be ok.