Posted by E B via SQLMonster.com on 11/23/05 08:50

Somebody have any ideas ????????????
TNX



E B wrote:
>Hi all !!!
>
>I use Sql server 2000.
>
>How can i copy entire table with data from one database to another (the
>databases are on the same server).
>
>I tried to use DTS but because of large amount of data this process taken a
>lot of time and also the log is growed up.
>
>Is there some thing wihout logging like Bulk Insert, only i need from table
>to table.
>
>Also i tried to copy data to flat file and after this to other database but
>it's rework
>
>Any suggestions appreciated.
>
>TNX in advance.
>

--
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

[Back to original message]