Posted by E B via SQLMonster.com on 11/27/05 11:31

However i think because of

> WHERE NOT EXISTS (SELECT .... FROM target WHERE ...)

it will also take a lot of time.

All that i need to do is to copy entire table with it's structure to other
database on the same server

i have 10 tables with aproximatly 3000000 rows, while i tried to use DTS for
sure LOG is growed up and it's taken a lot of time something like 1700000 in
a hour . (In the target table i don't have any constrints and indexes).

Thank Erland


E B wrote:
>TNX Erland,
>
>However i think because of
>> WHERE NOT EXISTS (SELECT .... FROM target WHERE ...)
>
>it will also take a lot of time.
>
>All that i need to do is to copy entire table with it's structure to other
>database on the same server
>
>i have 10 tables with aproximatly 3000000 rows, while i tried to use DTS for
>sure LOG is growed up and it's taken a lot of time something like 1700000 in
>a hour . (In the target table i don't have any constrints and indexes).
>
>Thank Erland
>
>>> Somebody have any ideas ????????????
>>
>[quoted text clipped - 30 lines]
>>if you are running in FULL or BULK_LOGGED mode, you would need to
>>backup the transaction log as the loop as running.
>

--
Imagination is more important then knowledge. (A.Einshtein)

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200511/1

• Next in forum: Re: How copy table data from one database to another
• Prev in forum: Re: Return pkID of last saved record - ASPUpload & @@Identity
• Thread view: Re: How copy table data from one database to another

[Reply to this message]