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.