Geeks With Blogs


Google My Blog

Catch me at: The List!

My InstallScript Utility Belt My Amazon Wishlist
My Standard Disclaimer

Chris G. Williams Beware: I mix tech and personal interests here.

as in, “I just got... “

I'm doing an Access to SQL Server migration. We've hit a few snags along the way, but I thought the “business owner” and I were basically on the same page.

I told her from the beginning that she could change the data all she wants and that was no big deal... I'm working with a copy of the Access db and the freshness of the data is irrelevant at the moment since i'm focusing on the 800+ queries and tables and DTS packages.
so the B.O. goes and changes a bunch of queries and table structures without telling me... and doesnt keep track of ANY of it... (stay tuned, it gets better)
So anyway... in the status meeting today the B.O. drops this bomb on me out of the blue!! When I try to explain that it will make things take longer because I'll need to update the queries and tables that changed, after we figure out WHAT was changed, and test it of course, the B.O. acts all surprised and says.... “but YOU said it was ok... that I could change things and it wouldnt impact you. YOU said it was ok...“
and I said... “No. I said you could change the DATA. Not the whole database.”
Fortunately, the boss took my side on the issue, but still... (pardon me while I pull the knife out of my back) I kept hearing sentences that started with “but HE SAID...“
*mumble grumble*  ...  meetings over.

You wouldn't change the engine while you're driving your car down the interstate would you?? Why would you think changing the schema and queries of the database while I'm migrating it... WITHOUT TELLING ME... would be a good idea?
Posted on Thursday, July 27, 2006 11:20 AM General Interest | Back to top

Comments on this post: sold out!

# re: sold out!
Requesting Gravatar...
I don't know if this'll help or not, but and have applications that compare differences between schemas and generate changescripts between SQL databases. Since you're working with Access -> SQL Server I don't know if these applications would be useful.

I think both companies provide similar
products, personally i use red-gate software, but i think they're very comparable in features.

Left by JustAnotherSQLGuy on Jul 27, 2006 12:33 PM

# re: sold out!
Requesting Gravatar...
You made 2 fatal mistakes.

1. Didn't get it in writing
2. Assumed she knew the difference between data and data strutures - so some poeple its just an access database.
Left by ZMan on Jul 28, 2006 1:55 PM

Your comment:
 (will show your gravatar)

Copyright © Chris G. Williams | Powered by: