Home Forums SQL Server 2014 Development - SQL Server 2014 Question about a composite key and autoincrement RE: Question about a composite key and autoincrement

  • February 23, 2018 at 6:18 am

    #1980910

    subramaniam.chandrasekar - Friday, February 23, 2018 12:56 AM

    herkusg - Thursday, February 22, 2018 9:19 PM

    Thanks for the replies guys,

    I will consider these options and see what I can do, It seems to me that any path I go the concurrency will be a problem..

    @gilamonster Looking forward for that blog.

    Yep, I have a query from my end, Why you are not certainly used SQL Server Migration Assistant (SSMA) ? A tool which helps much in these cases. Just a curious query...

    The manual computation of a unique number per combination of company and warehouse makes the use of SSMA considerably less valuable.   Not saying it couldn't be used for any of the other tables, but given the level of effort involved in using SSMA, it may not be worth it.   You have to judge those things on a case by case basis.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)