Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Resolved Question

Looking for software

Aug 22, 2011 12:15AM PDT

We have customers who buy our SaaS package, and if they want to convert their existing data (SO's Inventory, Customer information, etc) I need a tool that will do a "stare and compare" to match their existing tables/columns to ours, so we don't miss or loose anything. There are usually between SQL db's, not ACCESS to SQL. Any suggestions?

Discussion is locked

ladyzebra has chosen the best answer to their question. View answer

Best Answer

- Collapse -
This looks like a job for
Aug 22, 2011 5:03AM PDT

A developer to write a tool for you. You write that you have a software package for sale. Wouldn't you task your programmers to add this?
Bob

- Collapse -
HaHa...
Aug 22, 2011 6:08AM PDT

The developers were doing it, however it got handed off to me, a measly product manager to do, because "it's too much work" for a developer to do!

- Collapse -
Re: program
Aug 22, 2011 6:22AM PDT

To me, it seems like an essential part of the product. So the costs should have been included in the 'cost' part of the business case to develop this product.
Let's hope that - while they underestimated the costs - they didn't overestimate the revenue they will make. If they were wrong on that part also, it might be time to start looking for another job.

Kees

- Collapse -
Thanks Kees
Aug 22, 2011 10:15PM PDT

No, i don't think that anything was over or under estimated, just thinking outside the box to control costs and find a better way.

- Collapse -
Tipping my hand.
Aug 22, 2011 8:26AM PDT

My first SQL works were done over a decade ago and just issued some updates last month.

Why I add this is I have yet to find any tool that would do this for me. That is, when my app starts, the code checks for proper columns and more then upgrades the tables if need be.

It's something we put into the apps.
Bob

- Collapse -
Keep me posted
Aug 22, 2011 10:16PM PDT

When you do find this tool, let me know when you app is ready! Thanks for you help.