Importing same tables from multiple databases

[houssemabd]

Hello,

I have 17 DataBases on my sql Server.

each DataBase has 9 Tables with the same structre.

I want to import those 153 tables without doing it one by one, is that possible ?

Thanks,

[amitchandak]

@houssemabd , If they on the instance. You can create a view and DB and import.

You can also write SQL if needed in the advance editor of connection to append and get data. But Incremental might have issues