Microsoft SQL Server forum - Re: How copy table data from one database to another

Author

Re: How copy table data from one database to another

mika via SQLMonster.com

2005-11-22, 11:23 am

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

E B via SQLMonster.com

2005-11-22, 11:23 am

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

Sponsored Links