Re: How copy table data from one database to another

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 tabl
e
>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 webservertalk.com
http://www.webservertalk.com/Uwe/Fo...eneral/200511/1

Thanks its maybe good way to perfom my task, however because of while
inserting it writes to transaction log it makes a lot of time , and i have a
lot of table, i can't perform backup it's very huge db


mika  wrote:[color=darkred
]
>DTS is right way.
> 
>[quoted text clipped - 15 lines] 

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

Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...eneral/200511/1