Copy Queries

[pltnsgt]

I have 4 different sites with their own data source and have created 33 Queries for the first site. Is there a way I can copy the queries to the other sites instead of recreating them manually? All sites have their own data that is in the same format. All the information is in the same format and similar (different amounts, dates, but all in amount and date fields), they are named differently corresponding to their sites.

EX:
Site 1 Site 2

Data 1 Data 1
Data 2 Data 2

33 Queries (needs the same queries as site 1)

 

[James Deckert]

Possibility 1 would require you copy the database from site 1 to site 2.
To copy a query you'd probably import the query File>Get External Data>Import. Select the site database with the queries you want to import. Choose the Query tab. Select the queries to import and the OK button.

Possibilty 2 would be to open each query and view the SQL. From there you can copy/paste into an e-mail or word doc and take it to site two where you create a new query, then view SQL and paste from the e-mail. This method would be more cumbersome than method 1, but less problem than recreating the queries from scratch.

James