Page 1 of 1
Posted: Tue Nov 23, 2010 3:50 pm
by Malcolm
Anyone know an app that'll copy entities in general from one DB to another, avoiding things like constraint errors?
Posted: Tue Nov 23, 2010 4:03 pm
by TheCatt
RedGate SQL Comparison Bundle
I assume you mean in a MS-SQL environment? That's the best product I've ever used for copying DB objects and data.
Posted: Tue Nov 23, 2010 10:16 pm
by Malcolm
Word on the street was that we tried Red Gate some time ago. Allegedly choked. Think I need to revisit the specifics, because I just spent the past few months building a tool that does pretty much what that thing sounds like it's advertising. I'm giving 2 to 1 odds I've been duping functionality we could've bought.
Posted: Tue Nov 23, 2010 10:52 pm
by TheCatt
That stuff is gold. If you have issues, let me know. It has all sorts of settings for dropping constraints, etc before moving data, etc.
The only thing it has an issue with is non-keyed data, but that's cuz if you have non-keyed data, your DB sucks.
Posted: Wed Nov 24, 2010 4:28 pm
by Malcolm
Alright, revisited this...
Apparently when copying an entity from one DB to the next, RedGate can only do straight inserts, it can't dance around all the uniqueness constraints we've got.
Example (I think ...)
Environment A has Company X with ID 100. Environment B has Company Y with ID 100. If you want RedGate to copy X from A to B, I guess it chokes since there's already an existing Company with that PK/ID value? Or are my coworkers just too stupid to use RedGate correctly?
Posted: Wed Nov 24, 2010 6:10 pm
by TheCatt
Ah. So the problem is a general lack of process regarding test data.
Yeah, RedGate doesn't fix process problems. It just copies data.
Posted: Wed Nov 24, 2010 7:23 pm
by Malcolm
Yeah, our environment situation is ... beyond fucked up. All kinds of bullshit guidelines to follow (granted they're probably felonies if we fuck up).