Home - Customer - Case Studies

Customer Case Studies

Steel Manufacturer: Microsoft Dynamics Navision Database to SQL Database migration project

About Customer

The customer is the first integrated and largest in Tamilnadu, produces right from iron ore to heavy duty structural. The customer is engaged in manufacturing of international standard heavy size structural of Beams & Channels with annual capacity of 1, 80,000 MT. Apart from the main steel division, the customer has a coal based 8 MW captive power plant. The business is developed and promoted by a group of leading industrialists who where the pioneer in the iron and steel industry in South India.

Business Situation

The customer has implemented Microsoft Dynamics NAV version 4.0 for its Financial & SCM operations. But the company hasn’t realized complete ERP benefits and has many challenges. Also, the Navision database crashed twice within a span of one year and the system performance was not up to the mark. The company was interested to address the above challenges through the Navision database to SQL database migration project initiative. The customer engaged VELCOM to evaluate & select the right vendor & program manage this project.

Solution

VELCOM team evaluated various NAV vendors in the market & selected the right partner for this Navision database to SQL migration project. The project phases involve:

  • Perform "test database " for Navision (native) database
  • Take a latest backup for environment testing
  • Run the objects from the migrate utility
  • Identify & correct errors
  • Make a fresh backup after performing "test database "
  • Get the actual live data backup from the ERP server
  • Create a database on SQL Server
  • Restore the actual backup
  • Create / Synchronize the database users
  • Run test database for new SQL database
  • Assist Sys Admin for maintenance plans & Backup mechanisms
  • Post migration support

The entire project (including testing) was completed within 2 calendar weeks.

Key Benefits

  • The ERP environment has become more stabilized & robust
  • The data backup process was automated through scheduled data back up in SQL database

"VELCOM played key role in making our Microsoft Dynamics NAV project and Change management initiative a grand success. They have in-depth knowledge of ERP’s available and adopted suitable methodologies to meet our needs. Their services included Audit of NAV post implementation and IT infrastructure which was also carried out to our complete satisfaction." says Sr. Advisor Finance of the company.