Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Poor Man's Table Difference Expand / Collapse
Author
Message
Posted Tuesday, May 4, 2010 2:28 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 7:29 AM
Points: 15, Visits: 191
Comments posted to this topic are about the item Poor Man's Table Difference
Post #915661
Posted Thursday, May 6, 2010 7:54 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 9, 2013 8:32 AM
Points: 108, Visits: 166
Thanks for posting. It's a difficult problem at times; I was hoping I could borrow your approach for my own situation. But doing the True General Proc for this kind of thing would have to be a major project in its own, I can tell you.

My own situation is copying from ASE to SS; there are so many issues to be found - even things like "user copied a string with smart quotes from MS Word into a varchar field"; which is a character set incompatability no matter how well you try to match them.

My own choice to generate line-based text files and use Unix's sort/diff to get the cross platform differences had its problems too.

On pure SQL Server, however, I'm usually just using "except" with a little logic. Running on 64-bit servers, it's amazing how much can be done how quickly to find differences between results (not just "base tables", any result).

You gotta do what works. Too bad Fabian Pascal's predicted world of DRDBMS never came to pass.


Roger L Reid
Post #916976
Posted Thursday, May 6, 2010 11:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 13, 2012 11:42 AM
Points: 3, Visits: 40
If you're going to sync the DB's then eventually you need to find out what column/row is different. This solution doesn't address specific column and row to update in order to sync them which opens up a big can or worms.
Post #917247
Posted Thursday, May 6, 2010 7:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 7:29 AM
Points: 15, Visits: 191
jddddd2,

Just happens for my case that if the row is different, the newest row is plastered onto the other copy. But you're right...if the requirements need to look at columns, something more would be needed.
Post #917548
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse