Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2007-07-10 : 16:45:06
|
| There are two way to create duplicate table from another database:One is using "Import wizard", another is using "Insert..." statement.Which way is fast? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-10 : 16:53:29
|
| Similar, may spend more time to build package with the wizard. |
 |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2007-07-11 : 10:31:09
|
| you have one more to do this way likeselect * into db2.dbo.table2 from db1.dbo.table1Vichttp://vicdba.blogspot.com |
|
|
|
mharr
Starting Member
20 Posts |
Posted - 2007-07-11 : 13:55:34
|
| Or if the amount of data is large, and you want to control the batch sizes on inserting, you can use bcp and Bulk Insert.Mark |
|
|
|
|
|
|
Which way is fast? Import or insert?