I am using SQL Server 2008 and I need to select all data from one table of one DB into another table of another DB on the same SQL Server instance.

Here is my script using. The server will run out of memory. The data is big -- table is about 50G size on disk. Any easy alternative solution or any solution to lower memory consumption is fine. The server has 16G physical RAM and is x64.

Here is the statement I am using,

```
insert into [TargetDB].[dbo].[Orders]
select *
from [SourceDB].[dbo].[Orders];

```

Any quick and simple solutions?

thanks in advance,
George