Loop through the same tables in multiple databases

[#1]

I am working with an event management product that maintains separate MS-SQL databases for each event. One database keeps a list of all of the different databases. To create an app across all the databases, I need to create a loop that will

• draw the database name from the list;
• access the required database and tables;
• store the tables into qvds with the database name at the front of the qvd name e.g. AT_4313_EventDemographics.qvd; then
• move rinse repeat until all databases in the list have been addressed.

Any ideas?

[arulsettu · Accepted solution]

check this

Connections with more than one databases in the same document

[#3]

Worked like a charm - thanks. Now all I need to do is get the script to move on if there is an error.

[arulsettu]

if its is ok please close the thread by marking correct answer

thanks