Re: SqlServer Express, Firebird & stored procedure question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

allright!

although, truth to tell, this shareware project is not an immediate concern.
I have an other personal shareware project to finish first!
Using SQLite, so simple to use that I get picky!
But I would like to explore other options...

"Steven Ramacher" <sramacher@xxxxxxxxxxxxxxxx> wrote in message
news:76C53A4D-2A2C-428F-ADF0-BCA1F37FBAC9@xxxxxxxxxxxxxxxx
>I believe that you can script the installation for a silent installation of
> SQL Express 2005, and X-Copy your database. SQL server is a more feature
> rich
> database engine, but there is a price to pay in foot print size. In my
> opinion you would be better off scripting the installation of SQL server
> in
> your installer package and x-copy your database.
> I have been using Interbase/Firebird for sometime now and have had great
> success. There are subtle differences in the way you construct your SQL
> statements, for example you have to use quotes around table names that are
> mixed cased or have spaces in them such as "First Name" instead of [First
> Name]. One consideration that you must make is that there is no out of the
> box way to protect your connection string with Firebird. Firebird is very
> fast and is a great fit for many users.
>
> Good Luck,
>
> --
> Steven
>
>
> "Lloyd Dupont" wrote:
>
>> >I am not sure I agree with your concerns,
>> Do I have false assumptions?
>> Or do you just think that although what I said is true, it's not much an
>> issue in many case?
>>
>> > but I see no problem with going
>> > with Firebird as a database engine for your application. It certainly
>> > does
>> > have a much smaller footprint. SQL Express contains a lot more for the
>> > price
>> > (;->), but you may not need the firepower for your application, so I
>> > can
>> > understand the size issue.
>> >
>> > As for the SQL question. With all database engines you have ANSI SQL
>> > and
>> > proprietary SQL as options. If you stick with ANSI standard syntax, you
>> > will
>> > be able to use what you learn with both. This will not help you with
>> > T-SQL
>> > specific commands, however. So, yes, Firebird will help you, but not as
>> > much
>> > as working in SQL Express.
>> >
>> Allright, good to know!
>> Thanks you!
>>
>>
>>


.

Relevant Pages

  • Re: error messages practically worthless
    ... > Thanks, '69 Camaro ... You've posted this message on UseNet, a voluntary peer-to-peer forum, ... Since you are using SQL ... database engine, which applies the relationships, constraints, triggers, et ...
    (microsoft.public.access.externaldata)
  • Re: How to get all tables from Database?
    ... > relationaldata myrelationaldata = new relationaldata; ... >customers", myConnection); ... The SQL query has to tell ... >> the database engine explicitly what tables to use and how to join ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to get all tables from Database?
    ... > relationaldata myrelationaldata = new relationaldata; ... >customers", myConnection); ... The SQL query has to tell ... >> the database engine explicitly what tables to use and how to join ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Include pysqlite2 into Python 2.5?
    ... >> I think that a simple embedded relational database would be a good ... > default database engine, its API will rapidly become the de-facto ... > been discussions elsewhere about improving and simplifying the DB-API ... > I'd like to see a package into which you could plug different SQL ...
    (comp.lang.python)
  • Re: SQL parser
    ... You probably have to choose what database engine you want to parse it ... database engine - e.g. for SQL server, SQL DMO object library can do this. ...
    (microsoft.public.vb.general.discussion)