Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to compare queries betwen db's

Status
Not open for further replies.
jmnorby

jmnorby

Programmer
Joined
May 1, 2007
Messages
1
Location
US
Is there a way to compare the same queries between 2 versions of a db? We were thinking if there was an automated way to export the sql statements to a text file we could compare the txt files however we have hundreds of queries and don't want to do it manually. Any advice?

Thanks!
Jenn
 
Sort by date Sort by votes
You may use the SQL property of the QueryDef object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question Question
SQL data types in CREATE/ALTER TABLE queries
Replies
2
Views
3K
combo
combo
breezett93
  • Locked
  • Question Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
8
Views
766
breezett93
breezett93
TheresAlwaysAWay
  • Locked
  • Question Question
Union query provides different reslt than when summing the combined queries individually
Replies
12
Views
2K
TheresAlwaysAWay
TheresAlwaysAWay
C
  • Locked
  • Question Question
Query expression negative to a 0
Replies
6
Views
735
dhookom
dhookom
mhshane
  • Question Question
Is this the best way to do this query?
Replies
9
Views
590
mhshane
mhshane

Part and Inventory Search

Sponsor

Back
Top