Home Forums SQL Server 2014 Administration - SQL Server 2014 UniqueID's - multiple SQL instances deployed in different data centers RE: UniqueID's - multiple SQL instances deployed in different data centers

  • February 8, 2016 at 7:25 am

    #1857133

    cheshirefox (2/8/2016)

    I have SQL instances deployed in 3 data centers with increment ID columns. In each SQL instance, these columns must remain unique.

    Is there a native way in SQL to keep unique or will i have to generate programmatically?

    I know there in mySQL there is auto_increment_increment and auto_increment_offset.

    Any information you can provide is appreciated.

    By 'increment ID', I presume you mean Identity() columns?

    You could implement this through appropriate use of SEQUENCEs.

    Or you could switch to using GUIDs rather than identities to be assured of uniqueness.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.