Migrating from mssql to firebird: pro and cons

Posted by user193655 on Stack Overflow See other posts from Stack Overflow or by user193655
Published on 2010-06-03T08:40:39Z Indexed on 2010/06/03 8:44 UTC
Read the original article Hit count: 221

Filed under:

sql-server-express

|

firebird

i am considering the migration for 3 reasons:

1) SQLSERVER installation is a nightmar, expecially for 1-user software. Software installs in 10 seconds, SQLServer in 1 hour. Firebird installation is much easier.

2) SQLSERVER runs on windows server only

3) My customers have all the express edition

4) i am not using any advanced feature, I am now starting using filestream, but the main reason for this is that Express eidtion has 4/10GB db size limit

So these are all Pros of moving to Firebird.

Which are the cons?

I can also plan to support both platiforms, but this will backfire I fear.

© Stack Overflow or respective owner

Related posts about sql-server-express

SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.

as seen on SQL Authority - Search for 'SQL Authority'
Recently I had faced very interesting situation. Due to some reason we were not able to login into the production server for one of client. The reason for the same was that server was very busy, we had to login into the system and bring server to normal situation. When all the attempts failed, I decided… >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
Problem with importing an mdf created with SQL Server Express 2008 into SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
The question is probably extremely easy to resolve, but I need to resolve it because I need to carry on with my project. I am using SQL Server Express 2008 at home, and I've been working on an ASP.NET MVC app that stores my DB in an mdf file in the project's folder. The problem is that the SQL Server… >>> More
Scheduling Jobs in SQL Server Express - Part 2

as seen on SQL Team - Search for 'SQL Team'
In my previous article Scheduling Jobs in SQL Server Express we saw how to make simple job scheduling in SQL Server 2005 Express work. We limited the scheduling to one time or daily repeats. Sometimes this isn't enough. In this article we'll take a look at how to make a scheduling solution based… >>> More
Scheduling Jobs in SQL Server Express

as seen on SQL Team - Search for 'SQL Team'
As we all know SQL Server 2005 Express is a very powerful free edition of SQL Server 2005. However it does not contain SQL Server Agent service. Because of this scheduling jobs is not possible. So if we want to do this we have to install a free or commercial 3rd party product. This usually isn't allowed… >>> More

Related posts about firebird

How to migrate data from a Firebird database to PostGreSQL on Linux

as seen on Server Fault - Search for 'Server Fault'
Are there any good tools to migrate existing firebird databases to PostgreSQL for Linux systems? I've looked at: FBexport which can be used to dump the data as insert statements, but it's mainly written to export/import from one firebird db to another, not as a migration tool. There's also: Firebird… >>> More
Firebird .NET: Database backup not working (small file)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to backup my Firebird 2.5 database file by code: FbBackup backupSvc = new FbBackup(); backupSvc.ConnectionString = MyConnectionManager.buildConnectionString(); backupSvc.BackupFiles.Add(new FbBackupFile(backupPathFilenameAndExtension, 2048)); backupSvc.Verbose = true; backupSvc.Options… >>> More
Need to compare blobs in firebird

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys, I need to check on the contents of blobs in my databases (yes, plural, but one problem at a time). In one database, I have about 900 images of potentially varying sizes. I need to check to see if the versioning system that's built into our application is actually correctly replicating… >>> More
Does firebird support transactional schema changes?

as seen on Stack Overflow - Search for 'Stack Overflow'
Does firebird support transactional schema changes? It seems to me that MySQL does not (am I correct?). >>> More
Firebird sequence-backed ID shorthand

as seen on Stack Overflow - Search for 'Stack Overflow'
What do others do to simplify the creation of simple, serial surrogate keys populated by a SEQUENCE (a.k.a. GENERATOR) in Firebird = 2.1? I finc the process comparatively arduous: For example, in PostgreSQL, I simply type: pg> CREATE TABLE tbl ( > id SERIAL NOT NULL PRIMARY KEY, >… >>> More