compare two text files

Dear all,

What software can compare two text files? They are contains about 100k data generated from Visual Basic 6.0 program and MS SQL 2000. I have many files to compare daily. Please give me some suggestions. Thanks.

Alex

I think VSS (source safe) is suitable for that|||

thanks Eisa. it is helpful.

Could you suggest some freewares?

|||Hi Alex,
I don't know if it is allowed to share free software here or not, howere you can serach google for compare text files free|||Thank your for your help|||Windows has a command line utility (fc) that compares two files. Type "fc /?" at a command prompt, and it will list the options/switches. It's a good solution if it has the features you need, because it's built into Windows, and you won't have to bother installing it everywhere you need it. If you want to use it in a job, you can invoke it with an operating system type step, or use xp_cmdshell if you need to call it after dynamically building the command at run-time. In a job, you would have to pipe the results to another text file, for review.|||

CompareIt! - cool

http://www.grigsoft.com/

|||thanks a lot

compare two text files

Dear all,

What software can compare two text files? They are contains about 100k data generated from Visual Basic 6.0 program and MS SQL 2000. I have many files to compare daily. Please give me some suggestions. Thanks.

Alex

I think VSS (source safe) is suitable for that|||

thanks Eisa. it is helpful.

Could you suggest some freewares?

|||Hi Alex,
I don't know if it is allowed to share free software here or not, howere you can serach google for compare text files free|||Thank your for your help|||Windows has a command line utility (fc) that compares two files. Type "fc /?" at a command prompt, and it will list the options/switches. It's a good solution if it has the features you need, because it's built into Windows, and you won't have to bother installing it everywhere you need it. If you want to use it in a job, you can invoke it with an operating system type step, or use xp_cmdshell if you need to call it after dynamically building the command at run-time. In a job, you would have to pipe the results to another text file, for review.|||

CompareIt! - cool

http://www.grigsoft.com/

|||thanks a lot

compare

I am new SQL
I have XML files (jobs) that are generated from a third party app on a
weekly basis.
My SQL application loads the the xml files for production.

>From time to time changes will be made to the original xml files, which
requires a user to reload the job via the app.
However, the reporting process on these changes is somewhat anticquated
and sometimes these changes are missed and the job is not reloaded.
I am looking for a process to compare specfic dates values in the database
against either the file date on the xml files or the date that is
contained in the xml file and generate a report when the date is
in the DB is less then the file date
Any help is greatly appreciated.
Thank you
If you are using SQL Server 2005, look into the XQuery support that should
give you the comparison semantics...
Best regards
Michael
"steve" <steve@.discussions.microsoft.com> wrote in message
news:19713BEF-C2BD-46B8-A518-47656A51BA2C@.microsoft.com...
>I am new SQL
> I have XML files (jobs) that are generated from a third party app on a
> weekly basis.
> My SQL application loads the the xml files for production.
> requires a user to reload the job via the app.
> However, the reporting process on these changes is somewhat anticquated
> and sometimes these changes are missed and the job is not reloaded.
> I am looking for a process to compare specfic dates values in the database
> against either the file date on the xml files or the date that is
> contained in the xml file and generate a report when the date is
> in the DB is less then the file date
> Any help is greatly appreciated.
> Thank you
>

compare

I am new SQL
I have XML files (jobs) that are generated from a third party app on a
wly basis.
My SQL application loads the the xml files for production.

>From time to time changes will be made to the original xml files, which
requires a user to reload the job via the app.
However, the reporting process on these changes is somewhat anticquated
and sometimes these changes are missed and the job is not reloaded.
I am looking for a process to compare specfic dates values in the database
against either the file date on the xml files or the date that is
contained in the xml file and generate a report when the date is
in the DB is less then the file date
Any help is greatly appreciated.
Thank youIf you are using SQL Server 2005, look into the XQuery support that should
give you the comparison semantics...
Best regards
Michael
"steve" <steve@.discussions.microsoft.com> wrote in message
news:19713BEF-C2BD-46B8-A518-47656A51BA2C@.microsoft.com...
>I am new SQL
> I have XML files (jobs) that are generated from a third party app on a
> wly basis.
> My SQL application loads the the xml files for production.
>
> requires a user to reload the job via the app.
> However, the reporting process on these changes is somewhat anticquated
> and sometimes these changes are missed and the job is not reloaded.
> I am looking for a process to compare specfic dates values in the database
> against either the file date on the xml files or the date that is
> contained in the xml file and generate a report when the date is
> in the DB is less then the file date
> Any help is greatly appreciated.
> Thank you
>

Coming from ReportBuilder...

(warning: possibly stupid questions may follow)
I've currently in the process of porting a project written in Delphi with
reports generated in ReportBuilder 10.
I've never had anything to do with creating reports in a .NET environment
previously so I'm just wondering if there are any things I should be aware
of? The new application will be running off an SQL server 2005, but I would
also like it to be able to run off SQL server express.. Is this feasible?
I'm also wondering about the architecture.. Do the reports *have* to be
generated server side and be fetched via WS or can I embed reports in my
application and just fetch the data from the sql-server? If both methods are
doable, what's the best approach? The application will primarily be used
in-house with a small load but may be turned into a commercial project
somewhere down the road.
Any help is much appreciated!
HåvardWhich front-side client language will you be using? Delphi Win32, Delphi
.NET, C#, VB.NET?
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Håvard Olerud Eriksne" <hoeriksen@.SPAMMENOTgmail.com> wrote in message
news:ueB8gsTfIHA.2000@.TK2MSFTNGP03.phx.gbl...
> (warning: possibly stupid questions may follow)
> I've currently in the process of porting a project written in Delphi with
> reports generated in ReportBuilder 10.
> I've never had anything to do with creating reports in a .NET environment
> previously so I'm just wondering if there are any things I should be aware
> of? The new application will be running off an SQL server 2005, but I
> would also like it to be able to run off SQL server express.. Is this
> feasible? I'm also wondering about the architecture.. Do the reports
> *have* to be generated server side and be fetched via WS or can I embed
> reports in my application and just fetch the data from the sql-server? If
> both methods are doable, what's the best approach? The application will
> primarily be used in-house with a small load but may be turned into a
> commercial project somewhere down the road.
> Any help is much appreciated!
> Håvard|||On Mar 3, 4:14=A0pm, "Alain Quesnel" <alainsanss...@.logiquel.com> wrote:
> Which front-side client language will you be using? Delphi Win32, Delphi
> .NET, C#, VB.NET?
I'm writing the application using C# in VS2008|||In that case, you can use the .NET Report Control for either C# web apps or
C# windows apps. Personally, I prefer using the web based report server.
Then your reports are served via a web browser, which means zero deployment.
All you need on the client side is MSIE 6 or 7. End-users can even write
their own ad-hoc reports via a web browser with Report Builder (comes out of
the box with MSSQL/SSRS 2005).
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Håvard Olerud Eriksne" <hoeriksen@.SPAMMENOTgmail.com> wrote in message
news:ueB8gsTfIHA.2000@.TK2MSFTNGP03.phx.gbl...
> (warning: possibly stupid questions may follow)
> I've currently in the process of porting a project written in Delphi with
> reports generated in ReportBuilder 10.
> I've never had anything to do with creating reports in a .NET environment
> previously so I'm just wondering if there are any things I should be aware
> of? The new application will be running off an SQL server 2005, but I
> would also like it to be able to run off SQL server express.. Is this
> feasible? I'm also wondering about the architecture.. Do the reports
> *have* to be generated server side and be fetched via WS or can I embed
> reports in my application and just fetch the data from the sql-server? If
> both methods are doable, what's the best approach? The application will
> primarily be used in-house with a small load but may be turned into a
> commercial project somewhere down the road.
> Any help is much appreciated!
> Håvard|||"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:urzJlGXfIHA.5620@.TK2MSFTNGP04.phx.gbl...
> In that case, you can use the .NET Report Control for either C# web apps
> or C# windows apps. Personally, I prefer using the web based report
> server. Then your reports are served via a web browser, which means zero
> deployment. All you need on the client side is MSIE 6 or 7. End-users can
> even write their own ad-hoc reports via a web browser with Report Builder
> (comes out of the box with MSSQL/SSRS 2005).
OK, thanks. Since the application is based on WinForms I think I'll go with
the Report Control. Last question, is this similar(ish) to use as
ReportBuilder?
Cheers,
Håvard
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Håvard Olerud Eriksne" <hoeriksen@.SPAMMENOTgmail.com> wrote in message
> news:ueB8gsTfIHA.2000@.TK2MSFTNGP03.phx.gbl...
>> (warning: possibly stupid questions may follow)
>> I've currently in the process of porting a project written in Delphi with
>> reports generated in ReportBuilder 10.
>> I've never had anything to do with creating reports in a .NET environment
>> previously so I'm just wondering if there are any things I should be
>> aware of? The new application will be running off an SQL server 2005, but
>> I would also like it to be able to run off SQL server express.. Is this
>> feasible? I'm also wondering about the architecture.. Do the reports
>> *have* to be generated server side and be fetched via WS or can I embed
>> reports in my application and just fetch the data from the sql-server? If
>> both methods are doable, what's the best approach? The application will
>> primarily be used in-house with a small load but may be turned into a
>> commercial project somewhere down the road.
>> Any help is much appreciated!
>> Håvard
>|||I think so, but I haven't worked with Reporting Services in that manner.
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Håvard Olerud Eriksen" <hoeriksen@.SPAMMENOTgmail.com> wrote in message
news:uPStckXfIHA.4696@.TK2MSFTNGP05.phx.gbl...
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:urzJlGXfIHA.5620@.TK2MSFTNGP04.phx.gbl...
>> In that case, you can use the .NET Report Control for either C# web apps
>> or C# windows apps. Personally, I prefer using the web based report
>> server. Then your reports are served via a web browser, which means zero
>> deployment. All you need on the client side is MSIE 6 or 7. End-users can
>> even write their own ad-hoc reports via a web browser with Report Builder
>> (comes out of the box with MSSQL/SSRS 2005).
> OK, thanks. Since the application is based on WinForms I think I'll go
> with the Report Control. Last question, is this similar(ish) to use as
> ReportBuilder?
> Cheers,
> Håvard
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "Håvard Olerud Eriksne" <hoeriksen@.SPAMMENOTgmail.com> wrote in message
>> news:ueB8gsTfIHA.2000@.TK2MSFTNGP03.phx.gbl...
>> (warning: possibly stupid questions may follow)
>> I've currently in the process of porting a project written in Delphi
>> with reports generated in ReportBuilder 10.
>> I've never had anything to do with creating reports in a .NET
>> environment previously so I'm just wondering if there are any things I
>> should be aware of? The new application will be running off an SQL
>> server 2005, but I would also like it to be able to run off SQL server
>> express.. Is this feasible? I'm also wondering about the architecture..
>> Do the reports *have* to be generated server side and be fetched via WS
>> or can I embed reports in my application and just fetch the data from
>> the sql-server? If both methods are doable, what's the best approach?
>> The application will primarily be used in-house with a small load but
>> may be turned into a commercial project somewhere down the road.
>> Any help is much appreciated!
>> Håvard
>|||I think so, but I haven't worked with Reporting Services in that manner.
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Håvard Olerud Eriksen" <hoeriksen@.SPAMMENOTgmail.com> wrote in message
news:uPStckXfIHA.4696@.TK2MSFTNGP05.phx.gbl...
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:urzJlGXfIHA.5620@.TK2MSFTNGP04.phx.gbl...
>> In that case, you can use the .NET Report Control for either C# web apps
>> or C# windows apps. Personally, I prefer using the web based report
>> server. Then your reports are served via a web browser, which means zero
>> deployment. All you need on the client side is MSIE 6 or 7. End-users can
>> even write their own ad-hoc reports via a web browser with Report Builder
>> (comes out of the box with MSSQL/SSRS 2005).
> OK, thanks. Since the application is based on WinForms I think I'll go
> with the Report Control. Last question, is this similar(ish) to use as
> ReportBuilder?
> Cheers,
> Håvard
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "Håvard Olerud Eriksne" <hoeriksen@.SPAMMENOTgmail.com> wrote in message
>> news:ueB8gsTfIHA.2000@.TK2MSFTNGP03.phx.gbl...
>> (warning: possibly stupid questions may follow)
>> I've currently in the process of porting a project written in Delphi
>> with reports generated in ReportBuilder 10.
>> I've never had anything to do with creating reports in a .NET
>> environment previously so I'm just wondering if there are any things I
>> should be aware of? The new application will be running off an SQL
>> server 2005, but I would also like it to be able to run off SQL server
>> express.. Is this feasible? I'm also wondering about the architecture..
>> Do the reports *have* to be generated server side and be fetched via WS
>> or can I embed reports in my application and just fetch the data from
>> the sql-server? If both methods are doable, what's the best approach?
>> The application will primarily be used in-house with a small load but
>> may be turned into a commercial project somewhere down the road.
>> Any help is much appreciated!
>> Håvard
>|||"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:OseId8hfIHA.5624@.TK2MSFTNGP02.phx.gbl...
>I think so, but I haven't worked with Reporting Services in that manner.
OK, thanks. I've started looking into the issues now and it looks promising
:)
Håvard
> --
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Håvard Olerud Eriksen" <hoeriksen@.SPAMMENOTgmail.com> wrote in message
> news:uPStckXfIHA.4696@.TK2MSFTNGP05.phx.gbl...
>> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
>> news:urzJlGXfIHA.5620@.TK2MSFTNGP04.phx.gbl...
>> In that case, you can use the .NET Report Control for either C# web apps
>> or C# windows apps. Personally, I prefer using the web based report
>> server. Then your reports are served via a web browser, which means zero
>> deployment. All you need on the client side is MSIE 6 or 7. End-users
>> can
>> even write their own ad-hoc reports via a web browser with Report
>> Builder
>> (comes out of the box with MSSQL/SSRS 2005).
>> OK, thanks. Since the application is based on WinForms I think I'll go
>> with the Report Control. Last question, is this similar(ish) to use as
>> ReportBuilder?
>> Cheers,
>> Håvard
>>
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "Håvard Olerud Eriksne" <hoeriksen@.SPAMMENOTgmail.com> wrote in message
>> news:ueB8gsTfIHA.2000@.TK2MSFTNGP03.phx.gbl...
>> (warning: possibly stupid questions may follow)
>> I've currently in the process of porting a project written in Delphi
>> with reports generated in ReportBuilder 10.
>> I've never had anything to do with creating reports in a .NET
>> environment previously so I'm just wondering if there are any things I
>> should be aware of? The new application will be running off an SQL
>> server 2005, but I would also like it to be able to run off SQL server
>> express.. Is this feasible? I'm also wondering about the architecture..
>> Do the reports *have* to be generated server side and be fetched via WS
>> or can I embed reports in my application and just fetch the data from
>> the sql-server? If both methods are doable, what's the best approach?
>> The application will primarily be used in-house with a small load but
>> may be turned into a commercial project somewhere down the road.
>> Any help is much appreciated!
>> Håvard
>>
>
>