Select tables using Select staement and Inner Joins

Compares and synchronizes SQL database content.

Re: Select tables using Select staement and Inner Joins

Postby Brian Donahue » Wed Jul 21, 2004 5:50 pm

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.


Brian Donahue
Red Gate Technical

"Shai Goldberg" <gshai(RemoveThis)> wrote in message
> 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
> 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
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests