Page 1 of 1
SDAC to UNIDAC properties/methods mapping
Posted: Wed 30 Jun 2010 17:18
by brace
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.
Posted: Thu 01 Jul 2010 09:55
by Dimon
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.
Posted: Thu 01 Jul 2010 10:21
by brace
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?
Posted: Thu 01 Jul 2010 12:22
by Dimon
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.
Posted: Thu 01 Jul 2010 13:55
by brace
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?
Posted: Thu 01 Jul 2010 14:42
by Dimon
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.
Posted: Thu 01 Jul 2010 17:11
by brace
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...
Posted: Fri 02 Jul 2010 07:34
by Dimon
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.
Posted: Fri 02 Jul 2010 15:56
by brace
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
Posted: Tue 06 Jul 2010 11:13
by bork
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.
Posted: Tue 06 Jul 2010 15:07
by brace
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.
Posted: Wed 07 Jul 2010 14:12
by bork
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.