• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

Upgrading MS SQL Server, and needing to normalize data

I am involved with an organization that has a MS SQL Server database running with a program on a local LAN in the building where they work.  The organization is in the process of upgrading to a Cloud solution of the same (upgraded) software and the same MS SQL Server, from the same company.  In order for this to happen, the process is to take the old database, go through a normalization process of the tables to make it work with the Cloud version of the software.

The software company is not even doing the upgrade and normalization of the database tables, but my organization will be doing that.  On top of that, the software company will be charging my organization for doing the normalization.  Is this a normal business arrangement?  Has anybody seen anything like this before?  Any guidance would be helpful.

Thank you.
0
DigitalCro
Asked:
DigitalCro
1 Solution
 
PortletPaulfreelancerCommented:
In my experience with upgrading clients to a new version and/or moving to SaaS, the client is always responsible for the data quality. The vendor just cannot do this as the vendor's staff aren't intimately familiar with your business and the day to day detail of it.

However that does not mean the vendor moves the data for free, or has no testing to perform. The data migration can still be complex and it requires some testing before asking the client to verify it.

I'm not sure what you really mean by "normalization" of the data tables (I would expect the table design to already be normalized), but I suspect your vendor isn't charging for work that you are doing, instead they are charging for their portion of the effort.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Shouldn't the software company declare the compatibility with the cloud? Also, how it will be with the software licensing?
0
 
DigitalCroAuthor Commented:
Thank you for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now