asked on

Does Firebird support T-SQL?

I have a MS SQL Server Express database that I am going to migrate. I am looking at something that has a small footprint, easy (and I mean easy for a novice to install) and must be able to support T-SQL statements.

I have looked at MySQL, MS Server Express Compact (no T-SQL), and some others. Is Firebird my best choice, assuming it supports T-SQL?

imitchie

Yes, it does support T-SQL (transaction structured query language).
It may not however support all the commands you are used to.

rmmarsh

ASKER

Hmmm... is there another database engine that:

- is free
- supports T-SQL
- is very easy to install, or can be installed via command line (programmatically)
- has a small footprint (we are only dealing with maybe 50,000 records MAX!)

ASKER CERTIFIED SOLUTION

imitchie

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rmmarsh

ASKER

Sounds like Firebird is the way to go... if you don't mind my asking another question or two:

- can it be networked? I need the ability to have it reside on a machine so other machines in the network can access it. I didn't see anything either way.
- from what I can see, there is no installation at all; everything is in the .dll whiich is embedded in my application... is this correct?

imitchie

- can it be networked? I need the ability to have it reside on a machine so other machines in the network can access it. I didn't see anything either way.
- from what I can see, there is no installation at all; everything is in the .dll whiich is embedded in my application... is this correct?

Those are two different requirements:
You either embed it into the application, therefore it can access the database file directly; or
networked: install the firebird engine as a database server. Your applications become normal 2-tier clients.

rmmarsh

ASKER

Thank you so much... exactly what I was looking for...

R