copying database from sql2005 to sql2000 using SSIS and preserving identity

Posted on 2006-05-05
Last Modified: 2008-03-10
GREAT PROBLEMS! How to copy a database from MS SQL2005 to MS SQL2000 using SSIS AND (!!) keeping the Identitys and default values ?
Question by:Wassmann-DK
    1 Comment
    LVL 27

    Accepted Solution

    If you want to use the Identity values then SSIS is not the choice - unless you want to do a lot of typing. I dropped using SSIS and went to BULK INSERT with the KEEPIDENTITY option.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now