Porting from InterBase to MS SQL-Server 6.0

[Jacob Galley]

Hello.

Does anyone out there have any experience porting a DBMS from InterBase to
Microsoft SQL-Server 6.0? I am planning on developing a C/S system in Delphi
and Local InterBase, and then porting the DBMS to SQL-Server.

Two concerns:

1) Porting data. SQL-Server's Transfer Manager documentation says that it can
handle "non-Microsoft" servers. I wonder how smoothly it works with Local
InterBase.

2) Porting stored procedures and triggers. SQL-Server's Transact-SQL language
seems to be somewhat different than InterBase's dialect. Will recoding these
objects in Transact-SQL be a major headache or a minor nuisance?

The alternative to developing in InterBase before porting is, of course, to
simply bite the bullet and develop within SQL-Server. At this point I still
have that option. (The main drawback to this is that I'll have to buy C/S
Delphi before I've produced anything, which may be difficult.)

Any advice is appreciated,
Jake.

[John Lynn]

You could develop in Delphi on Windows NT Workstation, with SQL Workstation,
and do direct ODBC from Delphi? I know this is not ideal, but it's another
option... I wish Delphi C/S was not so expensive!