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 04, 2010 2:28 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 7:31 PM
Points: 15, Visits: 181
Comments posted to this topic are about the item Poor Man's Table Difference
Post #915661
Posted Thursday, May 06, 2010 7:54 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, September 09, 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 06, 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 06, 2010 7:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 7:31 PM
Points: 15, Visits: 181
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