Copying tables of different names

Question

Post reply

Copying tables of different names

brookr

Newbie

Points: 8
More actions
September 18, 2006 at 7:48 am

#76582

I think this should be simple but I cannot find out how to do it. I need to append a table of one name with the identical structure, to another table in the same DB. Can I do this in DTS?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Quick and dirty :

Select * INTO dbo.Table2 from dbo.table1 where 1 = 0

That will copy the columns only, you won't have any dri, constraints, defaults, indexes or keys.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 2

In DTS, if you're using the Import/Export Wizard, the default behavior is to append to an existing destination table. You can see this on the Column Mappings tab.

If you've created a package and are using a Transform Data task, the default is also to append to an existing table.

Greg

Robert Sterbal SSC Eights! Points: 845 More actions · Answer 3

what about

insert into table_to_add

select * from table_with_data

?

brookr Newbie Points: 8 More actions · Answer 4

Robert, that was EXACTLY what I needed! I could not get the syntax right. Gosh I thought it would be simple but this is ridiculous! Thank you so much!!! You made my day!