EndorsedendorsedOngoing

Access-to-SQL Server Migration with WordPress Web Interface

Services Covered:

Database Development and ManagementData MigrationWeb Application DevelopmentWebsite DevelopmentSoftware Maintenance and Support
Project hero — replace with case study imagery
Industry
Industry

Software Development

Duration
Duration

152 months

Budget
Budget

50K - 199K

Start Date
Start Date

1 January 2005

Team Size
Team Size

1-5

Engagement Model
Engagement Model

Offshore

Project Capability Score (PCS)

gauge meter
74/100
Good

Project Capability Score (PCS) estimates how capable Vibrant Info is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS


Client

Confidential

mapDetroit, United States of America

Project Summary

Vibrant Info provided database design, data migration, implementation, and server management for a software design company, migrating an Access-based system to SQL Server and building a WordPress front end. The vendor handled exports/imports, stored procedures and SQL Server jobs, and optimized the system for multi-user inventory management. The client praised the team's technical skill, reliable communication via Skype/Slack, around-the-clock availability, and honesty about capabilities.

Key Challenges

  • Overloaded internal team requiring external development support
  • Migrate an Access-based system to a scalable SQL Server with a web interface
  • Maintain ongoing maintenance contracts and support the client's growth

Project Deliverables

  • Migration of Access database to SQL Server
  • Web interface built with WordPress and PHP
  • Stored procedures and SQL Server jobs
  • Inventory management system with multi-user support
  • Data export/import and database implementation

Project Solution

During the client's project, Vibrant Info migrated an Access-based platform to a Microsoft SQL Server backend and built a web interface. They converted macros and Access tools into stored procedures and SQL Server jobs, optimized the database for multi-user access, and implemented inventory management for product descriptions and ingredients. The front end was developed in WordPress with PHP. The vendor also supported data exports and imports and assisted with database design, implementation, and migration. The team integrated with the client's staff and provided project management support.

Project Outcome

  • Reliable deliveries and around-the-clock support that met deadlines
  • Improved communication via Skype and Slack leading to clearer written requirements
  • Offshore team coordination provided continuous coverage with US in-house developers
  • Technically strong team able to deliver and honest about limitations

Platforms

  • WebWeb
  • CMSCMS

Tech Stack

  • PHPPHP
  • WordPressWordPress
  • Microsoft SQL ServerMicrosoft SQL Server

Client Endorsement

Overall Review Rating

4.75star5 out of 5 stars

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

Clients have been satisfied with the solutions and services provided by Vibrant Info. The team's impressive technical skill, reliable communication, and round-the-clock availability add value to the relationship. They are honest about their capabilities and willing to tackle difficult problems.

Anonymous

CTO

Note: This endorsement is based on publicly available client feedback from external review sources.

More Projects by Vibrant Info