Solved

Upgrading MS SQL Server, and needing to normalize data

Posted on 2015-01-28
3
154 Views
Last Modified: 2015-02-02
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
Comment
Question by:DigitalCro
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 49

Accepted Solution

by:
PortletPaul earned 500 total points
ID: 40576227
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
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40583720
Shouldn't the software company declare the compatibility with the cloud? Also, how it will be with the software licensing?
0
 

Author Closing Comment

by:DigitalCro
ID: 40584742
Thank you for your help.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question