Unanswered: Migrate data from one table to another without giving column names
I have two databases, I need to move the data from Table A of Database1 to Table B of Database2.
Schema of Table B in Database2 can be same as of Table A or it can contain few more columns which have default values specified.
I need to do it without specifying the columns names of any of the tables.
Is there any way to do it?