We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Large Table Move between Database

Aanvik
Aanvik asked
on
Medium Priority
202 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.
Comment
Watch Question

CERTIFIED EXPERT
Awarded 2008
Awarded 2008
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Its taking too much time. Don't we have any better approach.
CERTIFIED EXPERT
Awarded 2008
Awarded 2008

Commented:
No
CERTIFIED EXPERT
Awarded 2008
Awarded 2008

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

Author

Commented:
I just created the Primary key index.. Not other indexes.
CERTIFIED EXPERT
Awarded 2008
Awarded 2008

Commented:
you're going to be better off if you don't have that...especially if the PK is not an identity column...
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.