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.

Technical Skills:

SQL Server 2000/2005/2008R/2012; SSIS, SSRS, SSAS, VMware ESX, Sans, PL/SQL & T-SQL; Visual Basic (VB) 5/6, Visual Basic for Applications (VBA), SourceSafe for Visual Studio, Visual Studio Professional Edition 2005/2007/2010, VB.NET, ASP.NET, ADO.NET, VB Script, JavaScript, PHP, WordPress; MS Access 2.0, 97, 2002, 2007, 2010; Oracle 10g, SQL PLUS; Active X Data Object (ADO), Crystal Reports, ODBC, Distributed Component Object Model (DCOM), COM, TOAD, CSS, Oracle, HTML, XML, XQuery; Windows NT Server, Windows Server 2003/2008; Erwin; Windows 95/98/ 2000 ; Windows Server 2008R2; UNIX; MS-Office products, including Office and Visio

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.

1. I will migrate and map the correct datatypes in SQL server tables.
2. I will use ODBC to connect to SQL
3. I will troubleshoot any issues.
4. Add table indexes and primary keys
5. Make sure each table has an index and a primary key.
6. 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.
7. Check primary/foreign key relationships.
8. Make sure these relationships are based on fields with consistent data types and sizes.
9. 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.