Select tables using Select staement and Inner Joins

[Shai Goldberg]

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,

[Brian Donahue]

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,
>
>



_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521