Get prepared for a nice (but big) change coming for Lucity databases for our SQL Server clients. Historically, Lucity data has been spread across 10 databases (Comm, User, Work, Sewer, Storm, Street, Park, Water, Equip, and Electric). In Lucity 2015r2 (August 2015), a wizard will be provided to combine these databases into a single Lucity database. Data in a single database provides so many advantages for our clients including:
- Simpler database backup and maintenance plans
- Easier addition of new Lucity products
- Better database file management
- Improved cross database reporting
- Streamlined database connection management
In addition to these advantages, it allows us at Lucity to support new license models, add cool new features faster, and improve the overall stability of the software.
We are working hard to make the process of combining databases as easy and foolproof as we can. There will be a wizard provided which will walk through the process of pulling everything into a single database. It will automatically pull all of your Lucity tables, stored procedures, triggers, and data into the new database and will provide a comprehensive report of most custom objects in your databases. Custom objects must be manually transferred to the new database. This might include custom triggers, tables, views, security and schema, indexes, relationships, or stored procedures.
The process of combining databases can be done any time after upgrading to Lucity 2015r2 but must be done before upgrading to Lucity 2016 or higher. Oracle clients will not need to perform this process.
More information will be released in the next 3 to 4 months, in our release documentation for Lucity 2015r2, as well as at ACT in September.
Let us know if you have any questions or concerns, we are very interested in your feedback.