SQL Import Wizard

aneilg
aneilg used Ask the Experts™
on
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.
Comment
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
GO

select * into db1.table1 from db2.table1

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

Author

Commented:

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
Commented:
look at attachment
you must select edit mapping
and then select delete rows in destination table

1.JPG
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.

Commented:
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.

Author

Commented:
Thanks for your help once again guys.

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

thanks.

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