For my WAG I used COCOMO 81 with KLOC from the stored procedures and triggers, as feedback here implies that it will all have to be rewritten. I'm assuming that tables, views, and constraints can be converted with a migration tool.
-----Original Message----- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Rick Debay Sent: Monday, January 23, 2012 11:53 AM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] Sizing conversion project > You mean "beside licensing cost"? I was hoping to use a SWAG such as cost per LOC to estimate the database conversion cost; most of our code is in triggers, stored procedures, etc. > Do you use some Firebird specific features like Events? We have the hooks in place (Firebird generates events) but we don't have any apps that listen to the events right now. It's on the to-do list. > What programming language/libraries are used? .... > If code is not properly decoupled from database access it can mean rewrite of large portions of the codebase. We use Java. And I do my best to make sure the code is properly decoupled whenever I do a code review :) > why are you even considering I wasn't told. -----Original Message----- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Milan Babuskov Sent: Saturday, January 21, 2012 9:46 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Sizing conversion project Rick Debay wrote: > We are using Firebird and I've been tasked with determining the costs > for migrating to MS SQL Server. The last time I used the latter was > ten years ago, and in the role of a Java programmer. > Does anyone have any suggestions for how to come up with rough time > and cost estimates? You mean "beside licensing cost"? That depends largely on your applications and databases, so we would need more details: Do you use some Firebird specific features like Events? What programming language/libraries are used? It's easier to make a switch if you use Java application than if you use IBPP C++ library for example. Java might require a simple reconfiguration, while C++ would require rewrite of database access layer. If code is not properly decoupled from database access it can mean rewrite of large portions of the codebase. > Also, I'd like pointers to FB vs. SQL Server comparisons, so I add > those to the analysis. Obviously if the benefits don't exceed the > costs of the migration, it won't make sense. As someone who migrated from MSSQL to FB, I'd like you to first tell us why are you even considering going from rock-solid robust open source database to a closed one which has similar performance and feature set? -- Milan Babuskov ================================== The easiest way to import XML, CSV and textual files into Firebird: http://www.guacosoft.com/xmlwizard ================================== ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference. ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links
