I will perform database design, normalization and convert MS Access to SQL Server and SQL Server to Oracle for your back-end applications.
I have over 18 years of experience in programming, analysis, design, development, implementation, testing, and maintenance of application systems running under Internet/Intranet Web based and Client-Server environments and over 10 years of experience as an SQL Server, Oracle, Database Administrator (DBA)/Developer of object-oriented applications including MS Access/VBA, Visual Studio/VB.NET.
MS Access database has a size limit of 2 GB and can’t support more than 255 concurrent users. So, when it’s time for your Access database to go to the next level, I can migrate your tables, and map the correct datatypes to SQL Server for you, and I will guide you through the process.
- I will migrate and map the correct datatypes in SQL server tables.
- I will use ODBC to connect to SQL
- I will troubleshoot any issues.
- Add table indexes and primary keys
- Make sure each table has an index and a primary key.
- SQL Server requires all tables to have at least one index and requires a linked table to have a primary key if the table can be updated.
- Check primary/foreign key relationships.
- Make sure these relationships are based on fields with consistent data types and sizes.
- SQL Server does not support joined columns with different data types and sizes in foreign key constraints.
Why should you migrate data from SQL Server to Oracle?
Companies often migrate data from SQL Server to Oracle in order to take advantage of Oracle Database’s reliability, deployment flexibility, and reduced cost of ownership. And time-strapped IT teams—under pressure to meet the demands of round-the-clock business—need fast, cost-effective ways to migrate data from SQL Server to Oracle without harming the integrity of their data or disrupting business users.