Professional Web Applications Themes

Comparing two tables - Microsoft SQL / MS SQL Server

Hi, I would have to make code in C++ that would check two database tables for differencies. The two tables should be identical. If there are any differencies then it would have to write the result to a text file. Is there any other way than bcp to write the results to that text file? Any help would be appreciated. I'm using VC++ 6.0 for coding and have a SQL Server 2000. ---- mkarja...

  1. #1

    Default Comparing two tables

    Hi,

    I would have to make code in C++ that would check two database tables
    for differencies. The two tables should be identical. If there are any
    differencies then it would have to write the result to a text file.
    Is there any other way than bcp to write the results to that text file?
    Any help would be appreciated.
    I'm using VC++ 6.0 for coding and have a SQL Server 2000.

    ----
    mkarja
    mkarja Guest

  2. #2

    Default Re: Comparing two tables

    See this article:
    [url]http://www.sql-server-performance.com/vg_database_comparison_sp.asp[/url]
    Since you are writing C++ code that will read the table informtion off SQL
    Server and compare it in the application, why resort to writing the text
    file in SQL Server?? You can create the text file from your application and
    write to it as and when you see differences.
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    [url]http://www32.brinkster.com/srisamp[/url]

    "mkarja" <mmmc_reptailhotmail.com> wrote in message
    news:75a5303b.0307100305.22c150a9posting.google.c om...
    > Hi,
    >
    > I would have to make code in C++ that would check two database tables
    > for differencies. The two tables should be identical. If there are any
    > differencies then it would have to write the result to a text file.
    > Is there any other way than bcp to write the results to that text file?
    > Any help would be appreciated.
    > I'm using VC++ 6.0 for coding and have a SQL Server 2000.
    >
    > ----
    > mkarja

    SriSamp Guest

  3. #3

    Default Re: Comparing two tables

    Ok, thanks for the link. It seems to be just what I was looking for.

    ----
    mkarja


    "SriSamp" <ssampathsct.co.in> wrote in message news:<#sMkeYtRDHA.1552TK2MSFTNGP12.phx.gbl>...
    > See this article:
    > [url]http://www.sql-server-performance.com/vg_database_comparison_sp.asp[/url]
    > Since you are writing C++ code that will read the table informtion off SQL
    > Server and compare it in the application, why resort to writing the text
    > file in SQL Server?? You can create the text file from your application and
    > write to it as and when you see differences.
    > --
    > HTH,
    > SriSamp
    > Please reply to the whole group only!
    > [url]http://www32.brinkster.com/srisamp[/url]
    >
    > "mkarja" <mmmc_reptailhotmail.com> wrote in message
    > news:75a5303b.0307100305.22c150a9posting.google.c om...
    > > Hi,
    > >
    > > I would have to make code in C++ that would check two database tables
    > > for differencies. The two tables should be identical. If there are any
    > > differencies then it would have to write the result to a text file.
    > > Is there any other way than bcp to write the results to that text file?
    > > Any help would be appreciated.
    > > I'm using VC++ 6.0 for coding and have a SQL Server 2000.
    > >
    > > ----
    > > mkarja
    mkarja Guest

Similar Threads

  1. comparing Dates
    By Paul in forum Coldfusion Flash Integration
    Replies: 13
    Last Post: June 6th, 09:46 AM
  2. comparing 2 tables 1 database
    By adult.swim in forum Coldfusion Database Access
    Replies: 6
    Last Post: April 28th, 04:47 PM
  3. Comparing values
    By j1mmy webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 1
    Last Post: November 4th, 09:52 AM
  4. IP and hostname comparing
    By Bjerkås in forum PHP Development
    Replies: 7
    Last Post: October 11th, 10:18 PM
  5. Comparing rows in 2 tables
    By DA Morgan in forum Oracle Server
    Replies: 4
    Last Post: December 18th, 06:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139