| Author |
how to move data/objects faster with DTS
|
|
| Hassan 2005-07-26, 3:24 am |
| Is it faster to move data between 2 tables using DTS or more of an insert
<newtable> select * from <table>
I would like to use DTS but it appears very slow. Is there any setting to
make it faster ? Using the generic wizard to export data
| |
| Yogish 2005-07-26, 3:24 am |
| Hi Hassan,
You can turn off the logging, by selecting simple recovery mode, till you
finish copying. Also you can think of disabling the index on the destination
table, while moving the data.
--
- - - - - - - - -
Thanks
Yogish
"Hassan" wrote:
> Is it faster to move data between 2 tables using DTS or more of an insert
> <newtable> select * from <table>
>
> I would like to use DTS but it appears very slow. Is there any setting to
> make it faster ? Using the generic wizard to export data
>
>
>
| |
| Yogish 2005-07-26, 3:24 am |
| Also refer the following article for more details
http://www.mssqlcity.com/Tips/ bulk...ti
on.htm
--
- - - - - - - - -
Thanks
Yogish
"Hassan" wrote:
> Is it faster to move data between 2 tables using DTS or more of an insert
> <newtable> select * from <table>
>
> I would like to use DTS but it appears very slow. Is there any setting to
> make it faster ? Using the generic wizard to export data
>
>
>
| |
| Hari Prasad 2005-07-26, 3:24 am |
| Hi,
Use the BULK INSERT task in DTS package. Bulk insert is faster.
Thanks
Hari
SQL Server MVP
"Hassan" <fatima_ja@hotmail.com> wrote in message
news:esYPJCZkFHA.1372@TK2MSFTNGP10.phx.gbl...
> Is it faster to move data between 2 tables using DTS or more of an insert
> <newtable> select * from <table>
>
> I would like to use DTS but it appears very slow. Is there any setting to
> make it faster ? Using the generic wizard to export data
>
>
| |
| Hassan 2005-07-26, 3:24 am |
| isnt Bulk insert sources data from a file into SQL ?
My source and destination is SQL Server tables and are local too.
"Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
news:%23Mf4ThakFHA.3288@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Use the BULK INSERT task in DTS package. Bulk insert is faster.
>
> Thanks
> Hari
> SQL Server MVP
>
> "Hassan" <fatima_ja@hotmail.com> wrote in message
> news:esYPJCZkFHA.1372@TK2MSFTNGP10.phx.gbl...
insert[color=darkred
]
to[color=darkred]
>
>
| |
| Yogish 2005-07-26, 3:24 am |
| What he probably meant was, BCP OUT to a file and then use BULK INSERT to a
target table.
--
- - - - - - - - -
Thanks
Yogish
"Hassan" wrote:
> isnt Bulk insert sources data from a file into SQL ?
>
> My source and destination is SQL Server tables and are local too.
>
>
> "Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
> news:%23Mf4ThakFHA.3288@TK2MSFTNGP10.phx.gbl...
> insert
> to
>
>
>
|
|
|
|