I am in the process of exporting data from one database to another. (MS SQL 2008)
DB1 has many fields and not all will be exported.
DB2 will create a table with the selected fields to be imported
How can I create a script that will copy the table and the selected fields from DB1 to DB2
fields to export:
field names to import the above data
Those are the new names for the above fields (DB1). How can I copy the data and create the table and fields on DB2 with the above information ?