Hi Anthony, Guids are easiest way forward - due to their uniqueness and native support by the DB engine.
The only time I would consider using something else would be if there was a requirement for those unique row IDs to be 64bit integers for example or if there is a storage space concern - in this case I would consider using horizontal partitioning and allocating range of IDs to different instances reserving each one with a predefined range of values. On 2 May 2014 16:16, <anthonyatsmall...@mail.com> wrote: > Anyone doing database replications, are you using guids? Have any > recommendations or experiences? > > > > I don’t usually use guids but working on systems that may need to scale, > so thinking of switching to guids to avoid any future scalability issues > > > > > > Thanks in advance J > > > > Anthony > > > > >
