
Closed
Posted
Paid on delivery
I need an MS Access database migrated to a Firebird database. The database is less than 1GB in size. Requirements: - Migrate all tables from MS Access to Firebird and vice versa. - Migrate all tables from MS Access to MS SQL and vice versa. - Preserve any table relationships or constraints (to be confirmed). - Map data types to closest equivalent like Boolean to Small Int, Currency to single or double - Code should be in C# or VB.NET Ideal Skills and Experience: - Proficiency in MS Access and Firebird and MS-SQL - Experience with database migration - Experience in VB.NET and C# - Attention to detail for preserving relationships and constraints
Project ID: 40673085
61 proposals
Remote project
Active 7 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
61 freelancers are bidding on average $427 USD for this job

Hi, I can develop a reliable C# / VB.NET database migration utility to handle MS Access <-> Firebird and MS Access <-> MS SQL Server migrations. I will map Access data types to the closest Firebird/SQL equivalents, migrate all tables and data, and preserve relationships, keys, indexes, and constraints where applicable. I’ll also make the process bidirectional so data can be transferred back when required. I will focus on data integrity, accurate type conversion, and handling edge cases such as Boolean, Currency, Date/Time, AutoNumber, and text fields. I can provide clean, maintainable C# or VB.NET code and test the migration with row counts, schema validation, and data comparisons. I am available to start working immediately! I’m ready to review your Access database and start immediately.
$260 USD in 2 days
8.0
8.0

Hi, Let's discuss further over call? I will build this as a reusable migration utility rather than a one-off script, with clear type mapping, schema creation, data transfer, and validation between MS Access ↔ Firebird and MS Access ↔ SQL Server. I’ll also preserve primary/foreign keys and constraints where they exist and verify row counts after each migration. I have 20+ years of software development experience with extensive C#, VB.NET, SQL Server, database design, data migration, and enterprise data-processing work.
$250 USD in 7 days
5.2
5.2

I will build a robust migration tool in C# that handles the full bidirectional transfer between Access and Firebird, as well as Access and SQL Server. The solution will automatically map Access data types (like Currency to Double, Boolean to SmallInt) and preserve all table relationships and constraints during the process, ensuring data integrity without manual intervention.
$250 USD in 7 days
5.3
5.3

Hi, I can help migrate your MS Access database to Firebird and also support round-trip sync with MS SQL. Since you need tables, relationships, and data types preserved as closely as possible, I’d first review the schema, constraints, and any Access-specific fields that need careful mapping. I’ve worked on database migration tasks involving Access, SQL Server, and .NET, including type conversion, relationship recreation, and data transfer logic in C# and VB.NET. For your project, I’d build a clear migration path, validate each table and constraint, and make sure Boolean, Currency, and other fields are mapped to the closest Firebird or SQL Server equivalents. I’d focus on accuracy, repeatability, and clean code so the process can be reused if needed. If you’d like, I can outline the migration approach in more detail. Best regards, Gabriel
$250 USD in 7 days
3.9
3.9

Hi, This migration needs more than copying rows. The important part is creating deterministic mappings between Access, Firebird, and SQL Server so repeated imports and exports preserve keys, relationships, nullability, defaults, and numeric precision. I’d build the migration utility in C# with separate provider adapters and a shared schema-mapping layer. It would inspect table definitions, create destination tables in dependency order, transfer data in batches, restore indexes and foreign keys, and produce a validation report comparing row counts and rejected records. For financial values, I would map Access Currency to fixed-precision decimal types rather than floating-point fields to avoid rounding errors. I would also account for AutoNumber/identity handling, reserved field names, date conversions, Boolean differences, duplicate keys, and rollback when a table fails. The result would be maintainable code supporting Access ↔ Firebird and Access ↔ SQL Server in both directions. Should the utility migrate only tables and relationships, or must it also translate Access queries, indexes, defaults, and validation rules? Regards, Houssame
$500 USD in 7 days
4.0
4.0

I have experience working on similar database migration projects using MS Access, MS SQL, Firebird, and C#/.NET. I understand your requirements for two-way migration while preserving relationships, constraints, and accurate data-type mappings. I can build a reliable migration utility with proper validation and data integrity checks. Please come to inbox to discuss your database structure and migration workflow further.
$300 USD in 7 days
2.5
2.5

Hello! @Project@ I understand that you need to migrate an MS Access database to Firebird, SQL, and also ensure data integrity. @Why I'm a good fit@ My extensive expertise in database migration, particularly with MS Access, Firebird, and MS-SQL, paired with my strong skills in VB.NET and C#, makes me a reliable candidate for this project. I have spent the last several years solving exactly this type of migration challenge, ensuring flawless data transfer while preserving constraints and relationships. I'm ready to start working immediately. Thanks!
$500 USD in 5 days
3.0
3.0

As a seasoned programmer, I am more than capable of meeting your database migration requirements. My proficiency in both MS Access and Firebird, as well as my knowledge of MS SQL, makes me highly suitable for this project. I can skillfully migrate all tables between your databases with unwavering attention to detail. Data type mapping will not be a challenge since I possess the ability to identify the closest equivalents for effective migration. Not only do I acknowledge the importance of preserving table relationships and constraints but I also have significant experience doing so in previous projects. To execute this project accountability, my approach relies on my years of experience, which include employing C# and VB.NET- two crucial languages needed for your project. In summary, with my strong skill set in database migration, deep understanding of MS Access and Firebird as well as immense proficiency in C# and VB.NET, you can be assured that your project is in good hands. My motivations comes from devising creative solutions to intricate technical challenges and flooring my clients' objectives through the work I do.
$250 USD in 7 days
0.0
0.0

Hi, it's Kurt here ⭐️ The key here is that "migrating databases often leads to data loss if relationships and constraints aren't preserved." It seems like you ultimately want to ensure the integrity of your data during the migration process. What usually matters most here is "mapping data types accurately to avoid issues with functionality." A common issue is "overlooking dependencies between tables that can cause errors in the new system." With years of experience in database migration, I've helped bring seamless transitions for clients. You can expect a reliable setup that maintains your database's integrity and relationships. My core focus will be: • Detailed mapping of data types to prevent errors • Preserving table relationships for smooth functionality • Thorough testing to ensure all constraints are intact You can count on 5 Stars, strong communication, fast response times, and long-term relationships. Best, Kurt
$300 USD in 7 days
0.0
0.0

San Antonio, United States
Payment method verified
Member since Aug 26, 2026
₹12500-37500 INR
$250-750 USD / hour
₹1250-2500 INR / hour
$115-200 HKD / hour
₹12500-37500 INR
$30-250 USD
$1500-3000 AUD
₹1500-12500 INR
₹600-1500 INR
₹600-1000 INR
$250-750 USD
₹100-400 INR / hour
₹100-400 INR / hour
$15-25 USD / hour
₹750-1000 INR / hour
$250-750 AUD
$30-250 USD
₹12500-37500 INR
₹750-1250 INR / hour
$750-1500 USD