• The fastest way would be to script your QA environment Logins and permissions and then restore the Prod backups in QA and add your QA login back.

    or

    Since there is no connection between the Prod and QA servers, and you need just the Data (Tables) from prod to QA, try this approach :

    1.Use Generate scripts wizard on the prod server to generate the schema and data scripts of the 12 Databases and move the scripts to QA server(Genarating the schema and data option will differ depending upon the version of Sql Server).

    2.On the QA server, drop all the tables in those 12 Databases using the below :

    use [database1]

    go

    EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"

    go

    use [database2]

    go

    EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"

    go

    .......

    3. Directly execute the schema and table data script which was taken from Prod in the respective Databases by pasting them in SSMS, or if they are too large to open in the editor, use sqlcmd to load them :

    sqlcmd -S Servername -d Databasename -i Scriptpath

    (sqlcmd can take time depending upon the data in the tables)

    This will ensure that only the tables are recreated along with latest data in the QA environment.