Frequently Asked Questions

Q: Why can't I use SQL Server Express?

  • SQL Server Express does not support database replication.

Q: What if I am using SQL Server Express and can't upgrade?

  • For your trial you are able to supply .csv files containing Member, Project, Plan, Time Entry, and Task data. See Trial Data Import for more details.
  • Unfortunately there is no way to integrate with Mosaic without a Standard version of SQL Server. Alternatives you may consider are:
    • Upgrading to a cloud version of your current software

Q: Does Mosaic need unattended/ongoing access to our SQL Server Machine?

  • Mosaic needs to be able to access your server to complete the integration. After this we may request supervised access again for troubleshooting purposes, or to add additional data to your integration to support new features in Mosaic.

Q: Is it possible to set up Mosaic without copying our data to Mosaic’s cloud databases?

  • No. Mosaic does not offer any standalone solutions, all of our integrations require a cloud replication of the database.

Q: Can you set your sync to only take some of the tables from our database?

  • Yes. Mosaic only takes information from the Tables that are listed on the application's On-Premise Integration page.

Q: Do changes that are made in Mosaic get sent back to our database?

  • No. Data only flows in one direction, from your database to our Cloud database. Mosaic does not send any changes into your application's database.

Q: What security do you have in place for your cloud copy of our database?

  • Access to the copied database is protected by Azure Firewalls, Active Directory, and SQL Authentication.

Q: Can we use a backup database for our trial of Mosaic?

  • Yes. You can use a backup of your database for the trial. If you use a backup database you should note that the data you see in Mosaic will not necessarily be up-to-date with your live data. Also when you switch to a live database after your trial you may lose the changes that you made to your backup data (in Mosaic) during your trial.

Q: How can I make sure Replication Components are enabled on my SQL Server? If they’re not installed, how do I add them?

  • You can check if Replication Components are installed in SQL Server Management Studio by:
    • Expanding the server node in Object Explorer
    • Right-clicking on Replication and selecting "Launch Replication Monitor" or "Configure Distribution Wizard"
    • You will receive an error if Replication Components are not installed, similar to:

  • To install Replication Components:
  1. run the SQL Server Setup again. Choosing "New SQL Server stand-alone installation or add features to an existing installation" from the Installation menu on the left. Make sure to select “SQL Server Replication” on the Feature Selection page of the Installation Wizard.
  2. Restart your SQL Server Agent from SQL Configuration Manager.
  3. Repeat the steps above to confirm that Replication Components have been successfully installed.

NOTE: This process is typically done “after-hours” to avoid any disruption to your company’s daily activities.

Q: Do Work Categories and Phases get pulled over with dates?

  • Yes. They come over with dates from the "Standard Date" fields in your application's database.