Posted by mika via SQLMonster.com on 11/22/05 19:04

DTS is right way.



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

--
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: How copy table data from one database to another
• Thread view: Re: How copy table data from one database to another

[Reply to this message]