Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kaff
Starting Member
11 Posts |
 Posted - 2006-02-02 : 22:46:50
|
| HellO Experts,I am having a big problem to compare a data between two systems.Simple solution i want.I have two so called Identical files, which are generated from two differant system, and I want to make sure that those files are same.One way is that I can import them in two diferant tables, and then create a Stored procedure, to match them up by applying my logic, which is painfull.Is that Possible that I can do it through pre-defined SQL functions? or any utility? any tip is appriciated.Thanks in advance.Kaff |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-02 : 22:54:35
|
quote:
I have two so called Identical files, which are generated from two differant system, and I want to make sure that those files are same.
Since your source is in file, why not perform the comparision in file rather than import to tables and compare ? There are lots of file comparision utils in the net. You can also do it in command prompt using fc----------------------------------'KH' |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
kaff
Starting Member
11 Posts |
Posted - 2006-02-02 : 23:00:26
|
| Thanks for the feedback.As both files may contains the same data, but that might be on differant location!those text file utilities only compare line by line.. which is not 100% perfact as per my scenario.If you can think of any other usefull tip, I really appriciate it.Thanks again.Kaff |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-02 : 23:11:49
|
| >> those text file utilities only compare line by lineThere should be some that is able to perform binary comparision----------------------------------'KH' |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
kaff
Starting Member
11 Posts |
Posted - 2006-02-04 : 14:02:23
|
| Great.... It worked thanks everybody for your help.Kaff |
|
|
|
|
|
|
|
|
Is it Possible? To compare two Tables Data