Re: Convert Firebird table to SQL Server

Is there a tool that can perform a conversion of Firebird database to
SQL
Server ?

I have a very complex Firebird database and would like to create the
same
thing for SQL server without doing it manualy (at least minimizing the
things to change).


It all depends on what you want converted. If you just want to pump data
across then the tool mentioned by Ole works really well. If you want
something that can convert schema, views, procs etc, you are in trouble.
There is a significant difference between the SQL supported in Firebird
and SQLServer, especially in regard to stored procs.

Just a note --

Database Workbench can convert your tables, indices, unique, pk and
foreign key constraints constraints with a few mouse clicks.

It will not, however, transfer your SQL (it can transfer views, but any
dbms specific SQL will fail) or procedures/triggers unless both the source
and target use the standard SQL PSM syntax, which neither Firebird nor
MS SQL Server do.


Hope this helps.

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


.

Relevant Pages