You are here: Re: Question about move large amount of data from database to database « MsSQL Server « IT news, forums, messages
Re: Question about move large amount of data from database to database

Posted by Lee on 04/23/07 22:11

Plamen, Thanks a lot. I will try it and let you know the result.
Thanks again!

On Apr 23, 2:08 pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
> Yes, BCP will be a good option for fast data transfer. All of the BULK
> operations (BULK INSERT, SELECT INTO, BCP) are minimally logged when a non
> FULL recovery model is set.
>
> Another issue could be the purging of the archived records from your main
> table. If you have it as a single DELETE and it takes long time to complete,
> then you can break it into smaller DELETE chunks.
>
> If you have SQL Server 2005 Enterprise Edition, an interesting alternative
> is to use partitioned tables. Specifically range partitions based on date
> ranges (in your case could be weekly) can help with archiving. Take a look
> at the following article (in particular the section about Range Partitions):http://msdn2.microsoft.com/en-us/library/ms345146.aspx
>
> HTH,
>
> Plamen Ratchevhttp://www.SQLStudio.com

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация