DB copy tool

Post Reply
Malcolm
Posts: 32040
Joined: Fri May 21, 2004 1:04 pm
Location: Minneapolis

Post by Malcolm »

Anyone know an app that'll copy entities in general from one DB to another, avoiding things like constraint errors?
Diogenes of Sinope: "It is not that I am mad, it is only that my head is different from yours."
Arnold Judas Rimmer, BSC, SSC: "Better dead than smeg."
Top
TheCatt
Site Admin
Posts: 58193
Joined: Thu May 20, 2004 11:15 pm
Location: Cary, NC

Post 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.
It's not me, it's someone else.
Top
Malcolm
Posts: 32040
Joined: Fri May 21, 2004 1:04 pm
Location: Minneapolis

Post 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.
Diogenes of Sinope: "It is not that I am mad, it is only that my head is different from yours."
Arnold Judas Rimmer, BSC, SSC: "Better dead than smeg."
Top
TheCatt
Site Admin
Posts: 58193
Joined: Thu May 20, 2004 11:15 pm
Location: Cary, NC

Post 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.
It's not me, it's someone else.
Top
Malcolm
Posts: 32040
Joined: Fri May 21, 2004 1:04 pm
Location: Minneapolis

Post 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?
Diogenes of Sinope: "It is not that I am mad, it is only that my head is different from yours."
Arnold Judas Rimmer, BSC, SSC: "Better dead than smeg."
Top
TheCatt
Site Admin
Posts: 58193
Joined: Thu May 20, 2004 11:15 pm
Location: Cary, NC

Post 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.
It's not me, it's someone else.
Top
Malcolm
Posts: 32040
Joined: Fri May 21, 2004 1:04 pm
Location: Minneapolis

Post 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).
Diogenes of Sinope: "It is not that I am mad, it is only that my head is different from yours."
Arnold Judas Rimmer, BSC, SSC: "Better dead than smeg."
Top
Post Reply

Return to “Tech stuff”