Bulk Copy

[nayfeh]

Hi,

Can someone tell me how to copy a table in query analyser using the BULK COPY command. I have a very large table (4.5 GB) that I tried to copy in enterprise manager from one database to another, and it didn't work since the transaction log would fill up. I would like to omit the transaction log from running and I heard the way to do that is to use the BULK/COPY command.

Any help is appreciated.

Thanks,
TN

 

[wilk]

this is another way to do it, this will only work if the table does not exist in the new datbase


select * into otherdatabase..tablename from source_table

otherwise you will need to do

insert into otherdatabasae..tablename
(
columns go here, * will not work
)
select columns or * from source_table