Converting from Interbase to SQL Server

[Chris Poulain]

Hi,

We're trying to convert a database from Interbase to SQL Server. We've
extracted the metadata with the hope of using MS Query Analzyer to build the
SQL Server version.

The problem is that SQL commands that work in Interbase, do not work in SQL
Server. Silly me,..thought SQL was standard. :-)

So i'm wondering if there's some tool out there that will do the conversion?

Any ideas or comments would be appreciated.

Thanks,
Chris

[Jim Egan]

Have you tried Sybase PowerDesigner? Version 6 can reverse engineer
InterBase 4.0.
--
Jim Egan [TeamSybase]
Houston, TX
http://www.eganomics.com

Sybase Developers Network
http://sdn.sybase.com/sdn/mec/mec_home.stm

[Martijn Tonies]

> The problem is that SQL commands that work in Interbase, do not work in
SQL
> Server. Silly me,..thought SQL was standard. :-)

It is - but not the MS version...

--

Martijn Tonies
Upscene Productions

For InterBase Workbench,
the developer tool for InterBase
http://www.interbaseworkbench.com

For Delphi Components and InterBase tools:
http://www.upscene.com
"Chris Poulain" <chris....@garvin-allen.com> wrote in message
news:isJc5.48$Uc2....@sapphire.mtt.net...

[Rick van Dijk]

Chris,

Maybe you can use our tools: Importer Scripts for reverse engineering
(importing) your interbase database and dezign for databases for (re)generation
of your sql server scripts.

You can download evals from:
http://www.heraut.demon.nl

"DeZign for databases" is an easy-to-use;repository-based data modeling tool
that help you design databases for desktop and client/server applications.
"DeZign for databases" uses entity relationship diagrams (ERDs) to graphically
design databases. In your diagram you can visually make a design using entities,
relationships and text blocks. Supports:Oracle, Interbase, MS SQL Server, MySQL,
Informix, IBM DB2, dBase, Paradox, MS Access, ANSI Level2, Sybase and SQL
Anywhere.

To generate a diagram from existing database you can use Importer Scripts.
"ImportER Scripts" offers the ability to import SQL files containing DDL
statements for tables and domains (user defined datatypes) into the database
design tool "DeZign for databases". It incorporates a SQL parser that can derive
a graphical data model from such SQL scripts. When parsing SQL scripts,
"ImportER Scripts" captures complete specifications for column definitions,
object placement, table constraints,
and object definitions.

regards
Rick van Dijk
Heraut Solutions

Chris Poulain schreef:

> Hi,
>
> We're trying to convert a database from Interbase to SQL Server. We've
> extracted the metadata with the hope of using MS Query Analzyer to build the
> SQL Server version.
>

> The problem is that SQL commands that work in Interbase, do not work in SQL
> Server. Silly me,..thought SQL was standard. :-)
>