Solved

Large Table Move between Database

Posted on 2009-07-01
6
174 Views
Last Modified: 2012-05-07
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.
0
Comment
Question by:Aanvik
  • 4
  • 2
6 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 24755082
use SSIS, it is a quick and easy way to set this up to do this...it uses BULK INSERT, which is key for you in this scenario.

To do it, right click the source db, go to tasks, andthen export data.  from there, follow the wizard....save the package at the end so you can use it again if you need to.
0
 
LVL 5

Author Comment

by:Aanvik
ID: 24756331
Its taking too much time. Don't we have any better approach.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 24756602
No
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 60

Expert Comment

by:chapmandew
ID: 24756604
when you created the table on the destination db, did you make sure that you DID NOT copy the indexes as well?  
0
 
LVL 5

Author Comment

by:Aanvik
ID: 24756628
I just created the Primary key index.. Not other indexes.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 24756913
you're going to be better off if you don't have that...especially if the PK is not an identity column...
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question