| Subject | Re: [IB-Conversions] MySQL DB-->Firebird |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-03-28T07:56:33Z |
At 04:42 AM 28/03/2005 +0000, David K. wrote:
Since (as you say) you are very new to this and you don't say where you are
standing with respect to the software (end-user? developer? developer of
third-party products that use SAM?) then don't look for a miracle. For
example, migrating data from a database in the *format* used by one DBMS to
the *format* used by another is relatively simple, i.e. a way can usually
be found to do it.
What may matter more for a DBMS at the back-end of an existing software
product is the way data is managed. MySQL isn't useful for client/server
systems that need bomb-proof control of multiple concurrent read-write
clients; on the other hand, it is ideal for back-ending software that
needs load-once, read often data storage. That characteristic might well
be why the SAM developer chose MySQL at all...
As a SAM user, there would be a number of essential issues to understand
before committing yourself to your plan, including:
1) Does it need/can it work with concurrency support? If so, do you have
the means to manipulate transactions from your user/developer interface?
2) Does your software/interface depend on MySQL-specific data types like
identity or Boolean?
3) Is data integrity tightly bound to application code as, with MySQL, it
necessarily is?
4) ...and more...
All this is NOT to discourage you from experimenting with Firebird. Take a
copy of your MySQL database and just go for it. Even if you end up with a
database that your software doesn't like, you will have in your hand your
own personal Firebird database on which to cut your DBA teeth. If we are
all lucky, you will chronicle your experiences (failures and successes
alike) and have a HowTo that is sure to give someone else a much-need leg-up.
Helen
>I'm very new to this and am wondeirng if this is the right place toSee http://www.clevercomponents.com/products/datapump/dp-tour.asp
>post and ask.
>I am using a program called SAM from spacialaudio.com and I would like
>to completely move away from MYSQL, and use FireBird. How do I import
>the SAMDB from MySQL into FireBird?
Since (as you say) you are very new to this and you don't say where you are
standing with respect to the software (end-user? developer? developer of
third-party products that use SAM?) then don't look for a miracle. For
example, migrating data from a database in the *format* used by one DBMS to
the *format* used by another is relatively simple, i.e. a way can usually
be found to do it.
What may matter more for a DBMS at the back-end of an existing software
product is the way data is managed. MySQL isn't useful for client/server
systems that need bomb-proof control of multiple concurrent read-write
clients; on the other hand, it is ideal for back-ending software that
needs load-once, read often data storage. That characteristic might well
be why the SAM developer chose MySQL at all...
As a SAM user, there would be a number of essential issues to understand
before committing yourself to your plan, including:
1) Does it need/can it work with concurrency support? If so, do you have
the means to manipulate transactions from your user/developer interface?
2) Does your software/interface depend on MySQL-specific data types like
identity or Boolean?
3) Is data integrity tightly bound to application code as, with MySQL, it
necessarily is?
4) ...and more...
All this is NOT to discourage you from experimenting with Firebird. Take a
copy of your MySQL database and just go for it. Even if you end up with a
database that your software doesn't like, you will have in your hand your
own personal Firebird database on which to cut your DBA teeth. If we are
all lucky, you will chronicle your experiences (failures and successes
alike) and have a HowTo that is sure to give someone else a much-need leg-up.
Helen