×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

convert firebird to mssql ??

convert firebird to mssql ??

convert firebird to mssql ??

(OP)
Can anyone here point me in the right direction for gathering information on doing this?  Advantages/disadvantages/issues/howto's?

There is plenty of documentation doing it the reverse way, but what about going Firebird(IB6)-->MSSQL?

Tracey
Remember... True happiness is not getting what you want...

Its wanting what you have got!

RE: convert firebird to mssql ??

But, but, why?

What is it - exactly - that you would like to know?

Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird and MS SQL Server
http://www.upscene.com

RE: convert firebird to mssql ??

(OP)
Well, my boss thinks he might want to migrate (you know bosses, their reasons are purely political, he is not even an IT expert)

He is less keen now that i have pointed out the huge cost difference for licenses, but ultimately i think he wants to narrow down the Development tools we are using (he thinks having 4 languages and 4 DBMS's between 4 developers makes us a patchwork company and not proffessionally specialising in one - ie M$)

So, really what i am looking for is some kind of comparison of the two Db's.  

Tracey
Remember... True happiness is not getting what you want...

Its wanting what you have got!

RE: convert firebird to mssql ??

Ever had any hard locking issues with MSSQL? Well, you won't get them with Firebird.

Ever done BEFORE <action> triggers with MSSQL? Nope, you can't! But you can with Firebird.

CHECK constraints with sub-queries? Not in MSSQL, but yes, available in Firebird.

Clear and logical organized Stored Procedure language: Firebird.

Updateable views: Firebird.

On the other hand, MS SQL Enterprise comes with replication, a large collection of external functions (including DCOM stuff), SQL Mail and a SQL Server Agent.

In short: it all boils down to what you want...

Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird and MS SQL Server
http://www.upscene.com

RE: convert firebird to mssql ??

(OP)
ok thanks Martijn

I found a great white-paper that does an in-depth comparison, so i will weed my way through that.  It certainly looks like i will have MANY good arguments to keep Firebird!

Tracey
Remember... True happiness is not getting what you want...

Its wanting what you have got!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close