Database Design

Greenville, NC, North Carolina, Web Based Database Design

Convert Access - SQL Server

Is your Microsoft Access database serving your needs? Is Access becoming slower as more people are using it? Is your database growing larger in size or importance? Access may not be the right tool for the job any more.

Expert Access to SQL Consulting

If you need to convert your Access database to SQL Server, Productive Technology's expert consulting services can help you. We can upsize the database to give you the performance boost and reliability you want.

Upsizing Access

When Access Works Well

Access works well for small applications with five or fewer users. It is an excellent tool for prototyping larger database systems. Access can often be a good platform for initially developing systems quickly. Non-technical users can learn and use Access to create their own solutions.

Time to Upsize

Access begins to lose its luster as the business comes to depend upon the information stored within. As the volume of data grows, and becomes "mission critical", Access may no longer perform as a satisfactory database platform.

Upgrading to SQL Server

Access and SQL, a Logical Choice

Microsoft's SQL Server 2000 is a natural choice for upgrading from Access. Productive Technology will help you with your  Access to SQL Server Conversion effort. Many clients ask us to connect SQL Server to existing forms and reports in an Access database. This approach gives you the familiar convenience of Access forms, queries, and reports, while gaining SQL Server's robust data management features.

Cost-Effective Upgrade

Minimizing Conversion Costs

If your Access system is functionally adequate, it may not be necessary to re-write the forms, queries, or reports.  Inexperienced developers may perform unnecessary and costly rewrites of a satisfactory interface. Productive Technology can help you avoid unnecessary rewrites. Our experienced consultant will carefully analyze and plan the most appropriate course throughout the application's development.

Providing Value

When feasible and appropriate, we will modify the Access user interface just enough to use the new data source. Your data will now reside in a SQL Server 2000 database, with enhanced protection and performance for the business information you need.

Using MSDE or SQL Server 2000

Benefits of MSDE

Microsoft Data Engine (MSDE) is small-scale version SQL Server with many of the same benefits. It is Microsoft's introduction to SQL Server in a cost effective way. When appropriate, you can use MSDE at no additional software licensing cost. MSDE can be an ideal way to upgrade your Access programs to SQL Server.

Benefits of SQL Server

If you already have a SQL Server installation, or you will host multiple database applications, SQL Server may be the choice when upgrading. Your staff benefits from having all important data managed and backed up centrally and consistently.

Expert Consulting Assistance

Full Life Cycle Support

Productive Technology's experts can create and maintain your database applications. We help our customers throughout all aspects of a system's life. We are just as eager to get involved with an existing application as we are to begin a new system from scratch. Our service will last as long as you choose to keep your system.

User Interface Options

We specialize in simple and efficient Visual Basic .NET database user interfaces. With a custom interface, you have many more options and capabilities than Access provides. We can present your data in a web browser as well, so your data can be used in many locations from a central server.

New Life from Old Systems

Consider Redesign with Upsizing

If your application has limitations beyond that which an upsizing can address, we can help with addition design services to give you the capabilities you need. Our consultant will be able to explain all the options available so you can make the best decision.