Select tables using Select staement and Inner Joins
Brian Donahue
Posts: 6,590 Bronze 1
Hi Shai,
You can accomplish much the same thing in Data Compare by creating a
uniquely-indexed view on the server out of your query and then using Data
Compare to compare the indexed view in each database.
Hopefully this help some.
Regards,
Brian Donahue
Red Gate Technical
"Shai Goldberg" <gshai(RemoveThis)@shamir.co.il> wrote in message
news:gWEyUpxbEHA.3276@server53...
> Hi,
>
> Is there a way, when using the automation of the SQL Data Compare, to
> compare data from several tables using a select statement instead of table
> or view name.
> The select statement use I want to use may include inner joins and also
some
> where cluase.
>
> I have managed to perform a data compare with automation and by selecting
> some fields and not a Primary Key
>
> Thanks,
>
>
You can accomplish much the same thing in Data Compare by creating a
uniquely-indexed view on the server out of your query and then using Data
Compare to compare the indexed view in each database.
Hopefully this help some.
Regards,
Brian Donahue
Red Gate Technical
"Shai Goldberg" <gshai(RemoveThis)@shamir.co.il> wrote in message
news:gWEyUpxbEHA.3276@server53...
> Hi,
>
> Is there a way, when using the automation of the SQL Data Compare, to
> compare data from several tables using a select statement instead of table
> or view name.
> The select statement use I want to use may include inner joins and also
some
> where cluase.
>
> I have managed to perform a data compare with automation and by selecting
> some fields and not a Primary Key
>
> Thanks,
>
>
This discussion has been closed.
