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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2005-04-18 : 03:50:22
|
| Can you bulk insert from another database without using an "intermediate" file?I think the answer is no from looking at the documentation. But I'm just checking in case there is a workaround. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-18 : 04:10:10
|
| use dts instead of bcp perhaps--------------------keeping it simple... |
 |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2005-04-18 : 04:50:00
|
| If it's another db on the same server, you can just insert directly by fully qualifying the name of the source/destination object (depending on your connection) i.e. [db].[owner].[object]. If it's on another server, you can set up a linked server and do the same thing, just adding the server name before the db name.Mark |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-04-18 : 05:02:59
|
| mark,yeah that's what I'm doing.using bcp, you can set the batch insert size.can you set the amount of rows that are commited at a time for an INSERT statement? (I'm trying to get the db transaction log file to not grow to the size of several giggs during my export...) |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-04-18 : 05:43:09
|
| I'm also calling checkpoint between insert and delete statements in a script but it does not truncate the transaction log; it just keeps growing. How can I stop the transaction log from growing while also not allowing it to get full - without doing backups... |
|
|
|
|
|
|
BULK INSERT from DB and not file?