Solved

Upgrading MS SQL Server, and needing to normalize data

Posted on 2015-01-28
3
130 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
3 Comments
 
LVL 48

Accepted Solution

by:
PortletPaul earned 500 total points
Comment Utility
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 45

Expert Comment

by:Vitor Montalvão
Comment Utility
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
Comment Utility
Thank you for your help.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

771 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now