Solved

Large Table Move between Database

Posted on 2009-07-01
6
180 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
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.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

705 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