Solved

Large Table Move between Database

Posted on 2009-07-01
6
175 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

820 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