SQL Import Wizard

aneilg used Ask the Experts™
I want to import tables from one row to another but i want to overwire the existing table with the new table, but it looks like the wizard only appends to the existing table.

Is there any way to drop the table first then inport the tables.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
do you want to import from one server to another or in same server one database to another?

You can do something like this:

drop table db1.table1

select * into db1.table1 from db2.table1

it will create table1 in db1 and import all records from table1 of db2 to db1.table1



Its from the same server but a different database, the problem is there are over 60 tables, just thought there might be a way around it.
Consultant, Trainer
look at attachment
you must select edit mapping
and then select delete rows in destination table

Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Agree with reza_rad on this...You can select the option of 'Drop and Recreate destination table' if you want to have a fresh table.
Ritesh answer will have the problem if there is some relationship then drop will affect, but what reza has given will solve the problem for what ur looking for.


Thanks for your help once again guys.

reza was spot on, i am not bothered about the relationships, so thanks for pointing that out.


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial