<div>
Its taking too much time. Don't we have any better approach.
</div>


Its taking too much time. Don't we have any better approach.

<div>
when you created the table on the destination db, did you make sure that you DID NOT copy the indexes as well? &nbsp;
</div>


when you created the table on the destination db, did you make sure that you DID NOT copy the indexes as well?  

<div>
I just created the Primary key index.. Not other indexes.
</div>


I just created the Primary key index.. Not other indexes.

<div>
you're going to be better off if you don't have that...especially if the PK is not an identity column...
</div>


you're going to be better off if you don't have that...especially if the PK is not an identity column...

<div>
<div class="content wysiwyg-content">
We have a requirement where we need to move few very Large tables from Main database to another new database on the same server. <br />
There are 2 tables having more then 300 Million records.. What's the best way to move tables from one database to another db. Its SQL Server 2005.
</div>
</div>


We have a requirement where we need to move few very Large tables from Main database to another new database on the same server. 
There are 2 tables having more then 300 Million records.. What's the best way to move tables from one database to another db. Its SQL Server 2005.

Large Table Move between Database

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.