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