- SQL Server Express does not support database replication.
- 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 or Enterprise version of SQL Server. Alternatives you may consider are:
- Upgrading to a cloud version of your current software.
- 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.
- No. Mosaic does not offer any standalone solutions, all of our integrations require a cloud replication of the database.
- Yes. Mosaic only takes information from the Tables that are listed on the application's On-Premise Integration page.
- 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: 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:
- 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.
- Restart your SQL Server Agent from SQL Configuration Manager.
- Repeat the steps above to confirm that Replication Components have been successfully installed.
This process is typically done “after-hours” to avoid any disruption to your company’s daily activities.
Q: How can I check if Agent XPs are enabled on my SQL Server Management Studio, and how can I enable them?
- To check if Agent XPs are enabled on your SQL Server Management Studio, you can follow these steps:
- Open SQL Server Management Studio and connect to the SQL Server instance you want to check.
- In the Object Explorer, locate the
SQL Server Agentnode.
- Look for the status displayed beside
SQL Server Agent. If it shows "Agent XPs disabled," it means that Agent XPs are currently disabled.
- To enable Agent XPs, you can follow these steps provided in this article to enable Agent XPs on your SQL Server instance.
- Enabling Agent XPs will allow the SQL Server Agent to function properly.
- Once the Agent XPs have been enabled, you will be able to expand the
SQL Server Agentnode.
Replication jobs in SQL Server should automatically restart during server patches, ensuring continuous operation. To verify this:
- Open SQL Server Management Studio and connect to your server.
- In Object Explorer, expand
Replication > Local Publications > [Database]: Mosaic Publication.
- Right-click on the Subscription under
[Database]. Mosaic Publicationand select
View Synchronization Status.
- Verify there are no errors to ensure replication jobs are functioning correctly.
For Snapshot or Log Reader Agent issues, refer to Microsoft's guide: Troubleshooting Transactional Replication.
Updated 14 days ago