migration from ms-sql to firebird

Firebird may sometimes seem strange to newcomers. A few tips to make the
start easier:

* You need an admin tool. It's really hard to start without it. The
free ones are really poor - you need to try the commercial ones.
IBExpert has a free Personal Edition that does a great job.
* Install Firebird server on the development machine even that you
want to work with embedded Firebird. The admin tool will connect to the
database via the server.
* Make all names (table names, field names, SP names, etc.)
uppercase in the database. These names are converted to uppercase when
used from a client (and it might not match then). The other possibility
is to use quotation marks on both server and client - but you are making
your life harder. You should get used to uppercase on the server and you
can use whatever case you want on client.
* Read more about auto increment fields.


http://www.dotnetfirebird.org/blog/2005/02/migration-from-microsoft-sql-to.html

http://www.codeproject.com/useritems/MSSQLtoFireBirdMigration.asp