Firebird / Interbase to SQL Server Converter

Need more context? Compare DBConvert and DBSync side by side →

• Generators → IDENTITY / sequences. Creates SQL Server IDENTITY columns (or SEQUENCE objects when the generator is shared across tables) in place of Firebird's generator-based key assignment, and reseeds with DBCC CHECKIDENT above the loaded maximum key value — so the application's next insert does not collide.
• Domains. Expands Firebird domains (type, default, NOT NULL, CHECK) into concrete SQL Server column definitions so column behavior is transparent at the table level.
• BLOB subtypes. Maps BLOB SUB_TYPE 1 (text) to SQL Server nvarchar(max) and SUB_TYPE 0 (binary) to varbinary(max) by default, overridable per column.
• Character sets and collations. Re-encodes Firebird databases created on legacy WIN1252 / ISO8859_1 to Unicode on load and creates SQL Server string columns as nvarchar by default — per-column collations where ordering matters are reviewable in the type-mapping step.
• Stored procedures, triggers, and other procedural code — outside DBConvert's scope. DBConvert's migration covers tables (with their fields, types, defaults, and indexes), views, and foreign keys. Firebird PSQL stored procedures, triggers, computed-by columns, and event handlers stay in the source and are rewritten manually in T-SQL — PSQL EXECUTE STATEMENT, selectable SUSPEND, and WHEN exception handlers have no direct T-SQL equivalent. Typically a small fraction of the schema, but the one item the tool does not handle.