CodeSmith Community
Your Code. Your Way. Faster!

Identity insert

Latest post 06-13-2007 8:08 AM by katokay. 1 replies.
  • 06-13-2007 7:49 AM

    Identity insert

    I wish to copy database records from a Staging database to a Live database using .nettiers data layers methods. But I need to ensure that the identity columns are identical.

    How could I achieve this with .nettiers?

    Thanks Matt

    • Post Points: 35
  • 06-13-2007 8:08 AM In reply to

    • katokay
    • Top 25 Contributor
    • Joined on 07-09-2006
    • Salt Lake City, UT
    • Posts 143
    • Points 3,190

    Re: Identity insert

    At first thought the only way I can think of this working is to modify the templates, both the sprocs that are generated and the code that passes values to the sprocs. For migrating data if you have access to Sql Server Integration Services I would recommend it as that is what it is designed for. Our company has gone both routes in the past and prefer SSIS over .netTiers for migrating data both because it is faster at processing records, and it has various tools built in that handle migration scenarios like keeping the identity value.

     Edit: I should be more specific, SSIS comes with SQL Server 2005.

    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems