Data Compare inside of a replication

Brian Donahue

Hi Markus,

Thank you for posting to the newsgroup. I think that your problem is
related to one from an earlier post in which some of the tables were not
showing up in for selection in the compare databases wizard. This happens
because the tables are not schematically identical, and that includes the
names of the indexes on the columns of that table. I would recommend using
SQL Compare to check the structure of both tables and find the differences
that might cause this.

Also, make sure that you've got the latest version: 3.01.

Yours,

Brian Donahue
Red Gate Technical Support

"Markus Zwalina" <markus.zwalina@gfkl.com> wrote in message
news:P$Lmlq4eDHA.2912@server53...
> I wants to compare the table data from a replication between one publisher
> and their subscribers databases.
>
> But in the dialog from 'SQL Data Compare', where I can choose which table
I
> wants to compare, I see only some tables from the replication (round about
5
> from 30 from the replicated tables/article).
>
> All tables from the publisher databases are replicated in the subscriber
> database, whereas the subscriber databases have additionally tables, which
> can be find only here. All user tables have the the same owner, all but
the
> system tables. The strutcure of the replicated objects are the same in the
> publisher as in the subscriber database.
>
> If I compare the publisher database with a copy of itself, I will see all
> tables in the table-choose dialog.
>
> Have anybody of you some ideas ???
>
> Thanks, Markus
>
>

Brian Donahue

Hi Markus,

Thank you for posting to the Data Compare newsgroup. I believe that the
problem you're having is similar to one in an earlier post where tables were
not available in the compare databases wizard. The reason that this can
happen is that your tables are not schematically identical, and this
includes the index names having to be the same, too. I would recommend using
SQL Compare to look for the differences in your tables.

Also, please make sure you're using the latest version of the software,
which is 3.01.

Thanks,

Brian Donahue
Red Gate Technical Support

"Markus Zwalina" <markus.zwalina@gfkl.com> wrote in message
news:P$Lmlq4eDHA.2912@server53...
> I wants to compare the table data from a replication between one publisher
> and their subscribers databases.
>
> But in the dialog from 'SQL Data Compare', where I can choose which table
I
> wants to compare, I see only some tables from the replication (round about
5
> from 30 from the replicated tables/article).
>
> All tables from the publisher databases are replicated in the subscriber
> database, whereas the subscriber databases have additionally tables, which
> can be find only here. All user tables have the the same owner, all but
the
> system tables. The strutcure of the replicated objects are the same in the
> publisher as in the subscriber database.
>
> If I compare the publisher database with a copy of itself, I will see all
> tables in the table-choose dialog.
>
> Have anybody of you some ideas ???
>
> Thanks, Markus
>
>