Charlotte Foust
cfoust at infostatsystems.com
Fri Oct 16 11:00:26 CDT 2009
Just be aware that conversion tools do splendidly if what they're converting is fairly straight-forward objects and code. They fall in a heap over complex subforms and subreports. Charlotte Foust -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, October 16, 2009 7:10 AM To: 'Discussion concerning Visual Basic and related programming issues.' Subject: Re: [dba-VB] Access FE --> VB: Conversion/Rewrite Time? Hi Shamil, This is exactly what I was hoping would be available! Great! I have a direct conversion project with 175 forms/reports. Most are simple but some are complex. I also have 89 standard modules/class modules. SQL Server 2005 will contain the BE. So, this is a lot of work. I did find 2 software utility tools which will do conversion of objects in Access to objects in VB.Net. 1) http://www.microtools.us/ this is $160. 2) http://members.shaw.ca/irie/vbobjconverter.htm this is $250. If either even works fairly well, that would be the way to go. These both have demo versions so if someone wants to try them out and report back that would be helpful. I don't know enough of VB.Net yet to make a good assessment. Thanks! Dan -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Shamil Salakhetdinov Sent: Friday, October 16, 2009 6:24 AM To: 'Discussion concerning Visual Basic and related programming issues.' Subject: Re: [dba-VB] Access FE --> VB: Conversion/Rewrite Time? Hello Dan, I'd count it as one form/report => 1 day => times 2.5 = that would include all project costs not only development. But if you do not plan to change any functionality then it can be done quicker - here is a real life conversion case's stats online: http://northwind.codeplex.com/Thread/View.aspx?ThreadId=54924 The estimations were between 45 and 165 hours - just for conversion development work - average estimation was exactly around the final figure: ~65 hours for 35 forms/reports (with subforms/sureports). Final result is not "industry strong" - it would need another 60 hours to make it "industry strong", even more time would be needed to write docs and online help if needed etc. - all in all it will be 1 day for 1 form/report for such a simple application... Of course it also depends on how experienced your developers are, what architecture your converted system is planned to have etc. Thank you. -- Shamil -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, October 16, 2009 2:56 AM To: 'Access Developers discussion and problem solving'; 'Discussion concerning Visual Basic and related programming issues.' Subject: [dba-VB] Access FE --> VB: Conversion/Rewrite Time? I know some of you have done this! Do you have any general rules of thumb on how long the conversion or rewriting took you? Thanks! Dan _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4514 (20091016) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com