Re: how to pull all the tables at a time from database
SQL SELECT NAME
Will give you a resident table giving you all the table names in your database. If you want to save the tables to qvd you will need to loop through the tablenames and create a qvd for each one - a qvd holds one table only.
This script to loop through the tablenames could be like below. I haven't tested this and wrote it in a hurry so I suggest caution - start off with For i =1 to 1 or some other low number. It gives the gist of how to do it.