compare records

Hi,
We have 2 sql server on different location. Records are synchronized.
Checked the number of records on one table and some data are not copied. How
can I compare the records in a table on both servers , list only the records
that is non-existent on the other server. and eventually copy only those
missing records.
Thanks for any help!
Benny,
How are you synchronizing the records? Replication? Log shipping? If you
doing either of those, I wouldn't do an out of process synchronization. It
could really mess things up.
If you want to compare, you can attempt a link server and compare the two
tables, but depending upon your network connection, this could be
unworkable.
Bill
"Benny" <Benny@.discussions.microsoft.com> wrote in message
news:BC74991E-1869-45BC-9215-6068FDDC4240@.microsoft.com...
> Hi,
> We have 2 sql server on different location. Records are synchronized.
> Checked the number of records on one table and some data are not copied.
> How
> can I compare the records in a table on both servers , list only the
> records
> that is non-existent on the other server. and eventually copy only those
> missing records.
> Thanks for any help!
|||check out http://www.dbghost.com
"Benny" wrote:

> Hi,
> We have 2 sql server on different location. Records are synchronized.
> Checked the number of records on one table and some data are not copied. How
> can I compare the records in a table on both servers , list only the records
> that is non-existent on the other server. and eventually copy only those
> missing records.
> Thanks for any help!

compare records

Hi,
We have 2 sql server on different location. Records are synchronized.
Checked the number of records on one table and some data are not copied. How
can I compare the records in a table on both servers , list only the records
that is non-existent on the other server. and eventually copy only those
missing records.
Thanks for any help!Benny,
How are you synchronizing the records' Replication? Log shipping? If you
doing either of those, I wouldn't do an out of process synchronization. It
could really mess things up.
If you want to compare, you can attempt a link server and compare the two
tables, but depending upon your network connection, this could be
unworkable.
Bill
"Benny" <Benny@.discussions.microsoft.com> wrote in message
news:BC74991E-1869-45BC-9215-6068FDDC4240@.microsoft.com...
> Hi,
> We have 2 sql server on different location. Records are synchronized.
> Checked the number of records on one table and some data are not copied.
> How
> can I compare the records in a table on both servers , list only the
> records
> that is non-existent on the other server. and eventually copy only those
> missing records.
> Thanks for any help!|||check out http://www.dbghost.com
"Benny" wrote:

> Hi,
> We have 2 sql server on different location. Records are synchronized.
> Checked the number of records on one table and some data are not copied. H
ow
> can I compare the records in a table on both servers , list only the recor
ds
> that is non-existent on the other server. and eventually copy only those
> missing records.
> Thanks for any help!

compare records

Hi,
We have 2 sql server on different location. Records are synchronized.
Checked the number of records on one table and some data are not copied. How
can I compare the records in a table on both servers , list only the records
that is non-existent on the other server. and eventually copy only those
missing records.
Thanks for any help!Benny,
How are you synchronizing the records' Replication? Log shipping? If you
doing either of those, I wouldn't do an out of process synchronization. It
could really mess things up.
If you want to compare, you can attempt a link server and compare the two
tables, but depending upon your network connection, this could be
unworkable.
Bill
"Benny" <Benny@.discussions.microsoft.com> wrote in message
news:BC74991E-1869-45BC-9215-6068FDDC4240@.microsoft.com...
> Hi,
> We have 2 sql server on different location. Records are synchronized.
> Checked the number of records on one table and some data are not copied.
> How
> can I compare the records in a table on both servers , list only the
> records
> that is non-existent on the other server. and eventually copy only those
> missing records.
> Thanks for any help!|||check out http://www.dbghost.com
"Benny" wrote:
> Hi,
> We have 2 sql server on different location. Records are synchronized.
> Checked the number of records on one table and some data are not copied. How
> can I compare the records in a table on both servers , list only the records
> that is non-existent on the other server. and eventually copy only those
> missing records.
> Thanks for any help!

Compare Databases

I replicated two databases. How do I find out the data from one database is
copied over to the other DB?Hello,
How did you replicate the database:-
1. Is it SQL Server replication
2. Backup and Restore
3. Detach and Attach
IN most of the above cases data will be on sync.
You could use the SQLCompare from Redgate software..
http://www.red-gate.com/products/SQL_Compare/index.htm?gclid=CIXG1o28_4gCFTzqJAod5Bjhdw
Thanks
Hari
"morphius" <morphius@.discussions.microsoft.com> wrote in message
news:A7F9C2AD-55A6-4E45-9496-CB06F9BD1E8A@.microsoft.com...
>I replicated two databases. How do I find out the data from one database is
> copied over to the other DB?

Compare data in tables after inserting?

I'm new to bcp and am trying to import the data from an existing
table into a new table (copied from the existing table).
I ran these:
execute xp_cmdshell 'bcp database.dbo.table out c:\temp\table.txt
-Sserver -T -n'
bulk insert database.dbo.tableA from 'C:\temp\table.txt'
with (DATAFILETYPE = 'native')
Everything seemed to be fine, no error messages. When I ran select
count on the original and the destination, and got very different
values
select count (*) from dbo.table
1140089
select count (*) from dbo.tableA
205272
Why is there such a discrepancy? How should I go about making sure the
data in the tables match, or get them to match, post insert? TIA!
Was there existing data in tableA at the time of the import? A count(*) is
a quick way to compare row counts. A more complete solution would be to use
a third-party data comparision tool i.e.,
http://www.red-gate.com/products/SQL...pare/index.htm .
HTH
Jerry
"nmsm" <naomimsm@.gmail.com> wrote in message
news:1127747561.868201.208900@.f14g2000cwb.googlegr oups.com...
> I'm new to bcp and am trying to import the data from an existing
> table into a new table (copied from the existing table).
> I ran these:
> execute xp_cmdshell 'bcp database.dbo.table out c:\temp\table.txt
> -Sserver -T -n'
> bulk insert database.dbo.tableA from 'C:\temp\table.txt'
> with (DATAFILETYPE = 'native')
>
> Everything seemed to be fine, no error messages. When I ran select
> count on the original and the destination, and got very different
> values
> select count (*) from dbo.table
> 1140089
> select count (*) from dbo.tableA
> 205272
> Why is there such a discrepancy? How should I go about making sure the
> data in the tables match, or get them to match, post insert? TIA!
>
|||There was no exisiting data in tableA at the time of import, which is
another reason the select difference surprised me.
Is there another way of comparing without a third-party comparison
tool?

Compare data in tables after inserting?

I'm new to bcp and am trying to import the data from an existing
table into a new table (copied from the existing table).
I ran these:
execute xp_cmdshell 'bcp database.dbo.table out c:\temp\table.txt
-Sserver -T -n'
bulk insert database.dbo.tableA from 'C:\temp\table.txt'
with (DATAFILETYPE = 'native')
Everything seemed to be fine, no error messages. When I ran select
count on the original and the destination, and got very different
values
select count (*) from dbo.table
1140089
select count (*) from dbo.tableA
205272
Why is there such a discrepancy? How should I go about making sure the
data in the tables match, or get them to match, post insert? TIA!Was there existing data in tableA at the time of the import? A count(*) is
a quick way to compare row counts. A more complete solution would be to use
a third-party data comparision tool i.e.,
http://www.red-gate.com/products/SQ...mpare/index.htm .
HTH
Jerry
"nmsm" <naomimsm@.gmail.com> wrote in message
news:1127747561.868201.208900@.f14g2000cwb.googlegroups.com...
> I'm new to bcp and am trying to import the data from an existing
> table into a new table (copied from the existing table).
> I ran these:
> execute xp_cmdshell 'bcp database.dbo.table out c:\temp\table.txt
> -Sserver -T -n'
> bulk insert database.dbo.tableA from 'C:\temp\table.txt'
> with (DATAFILETYPE = 'native')
>
> Everything seemed to be fine, no error messages. When I ran select
> count on the original and the destination, and got very different
> values
> select count (*) from dbo.table
> 1140089
> select count (*) from dbo.tableA
> 205272
> Why is there such a discrepancy? How should I go about making sure the
> data in the tables match, or get them to match, post insert? TIA!
>|||There was no exisiting data in tableA at the time of import, which is
another reason the select difference surprised me.
Is there another way of comparing without a third-party comparison
tool?

Compare data in tables after inserting?

I'm new to bcp and am trying to import the data from an existing
table into a new table (copied from the existing table).
I ran these:
execute xp_cmdshell 'bcp database.dbo.table out c:\temp\table.txt
-Sserver -T -n'
bulk insert database.dbo.tableA from 'C:\temp\table.txt'
with (DATAFILETYPE = 'native')
Everything seemed to be fine, no error messages. When I ran select
count on the original and the destination, and got very different
values
select count (*) from dbo.table
1140089
select count (*) from dbo.tableA
205272
Why is there such a discrepancy? How should I go about making sure the
data in the tables match, or get them to match, post insert? TIA!Was there existing data in tableA at the time of the import? A count(*) is
a quick way to compare row counts. A more complete solution would be to use
a third-party data comparision tool i.e.,
http://www.red-gate.com/products/SQL_Data_Compare/index.htm .
HTH
Jerry
"nmsm" <naomimsm@.gmail.com> wrote in message
news:1127747561.868201.208900@.f14g2000cwb.googlegroups.com...
> I'm new to bcp and am trying to import the data from an existing
> table into a new table (copied from the existing table).
> I ran these:
> execute xp_cmdshell 'bcp database.dbo.table out c:\temp\table.txt
> -Sserver -T -n'
> bulk insert database.dbo.tableA from 'C:\temp\table.txt'
> with (DATAFILETYPE = 'native')
>
> Everything seemed to be fine, no error messages. When I ran select
> count on the original and the destination, and got very different
> values
> select count (*) from dbo.table
> 1140089
> select count (*) from dbo.tableA
> 205272
> Why is there such a discrepancy? How should I go about making sure the
> data in the tables match, or get them to match, post insert? TIA!
>|||There was no exisiting data in tableA at the time of import, which is
another reason the select difference surprised me.
Is there another way of comparing without a third-party comparison
tool?

Communication link failure

I am running an SSIS packsge across 2 servers. There at 33 Mil rows being copied over. At 5.6 mil rows I get this

[OLE DB Source [1]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "Protocol error in TDS stream". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "Communication link failure". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "Communication link failure". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "Communication link failure". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "TCP Provider: The specified network name is no longer available. ".

[DTS.Pipeline] Error: The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Is there any known cause of this?

Thanks

Looks like a connection problem and that something, somewhere starts to drop packets or even the connection. You might have to enlist the help of the network guys if such people exist where you're at.