So, I’m running Openfire 3.6.4 on 64bit JVM and MS Sql 05 Enterprise.
Hopefully this is not a stupid query to make of the community (See what I did there… sorry)
Anyways, There are a handful of tables which do not have unique identifiers on them. It may not be required for functionality however in my best practices we always include a unique id on everytable just because and for future proofing. . .and also because it allows you to make Transactional replication between two SQL servers making it much easier to institue a Staging Server and Failover Server.
But to get to brass tacks, I’m pretty sure it will be fine but I wanna double check with everyone before I waste a bunch of time testing it out.
Can I add a new column to tables without unique identifiers and backfill then add an autoincrement and not breaka mah servuh.
Thanks for your time.
Also I love the platform and I’m digging hard into fastpath right now because I’m trying to replace our companies current helpdesk with a fastpath solution; as we would have to shell out a Mill to the former company we came from to keep the existing helpdesk in tact, and F THAT.