Average Ratings 11 Ratings

Total
ease
features
design
support

Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Description

KS DB Merge Tools is an easy to use diff & merge tool for MySQL, MariaDB, Oracle Database, SQL Server, PostgreSQL, MS Access, SQLite and Cross-DBMS databases allowing to compare and sync both schema and data. Starting with a schema changes summary, results can be narrowed down to object lists of particular object type (table definitions, views, etc.), and then down to definition of particular object. Data changes can be retrieved as a high-level list of changes totals across all tables in the database, each total row count can be observed as a side-by-side list of rows for the given table, each changed row can be analyzed for changes in each column. Various diff results provide quick filters to show only new/changed/new+changed items (schema objects or table data rows), ability to select required changed items and generate scripts to apply these changes to the other side database. This script can be executed immediately or saved for future use.

Description

ProjectSync efficiently replicates project entities—such as projects, tasks, and resources—into a SQL database, significantly reducing the time required to respond to events in Project Online, like saving or publishing. It can be set up to utilize the same database as ListSync, enabling seamless integration of Project Site list data and Project Online entity data within queries. The solution stores SharePoint list information in a Microsoft SQL Server database, and users can select either an Azure SQL database or an On-premise SQL Server based on their needs. Additionally, it facilitates data connection to existing reporting systems, including BI Service, Power BI, and Tableau. ProjectSync also allows for the creation of multiple environments, which is advantageous for managing development, testing, and production release processes. Furthermore, departments can have their data segregated into different databases, accommodating instances such as ICT and operations if they utilize separate Project Online instances. ThorApps provides its own secure SSRS farms for storing this data, ensuring safety and accessibility. By offering these robust features, ProjectSync not only enhances data management but also streamlines workflow processes across various departments and reporting platforms.

API Access

Has API Yes 

API Access

Has API No 

Screenshots View All

Screenshots View All

Integrations

SQL Server Yes 
Azure SQL Database No 
BI Service for SharePoint No 
Microsoft Power BI No 
Microsoft Project No 
Microsoft SharePoint No 
MySQL Yes 
Oracle Database Yes 
PostgreSQL Yes 
SQLite Yes 
Tableau No 

Integrations

SQL Server Yes 
Azure SQL Database Yes 
BI Service for SharePoint Yes 
Microsoft Power BI Yes 
Microsoft Project Yes 
Microsoft SharePoint Yes 
MySQL No 
Oracle Database No 
PostgreSQL No 
SQLite No 
Tableau Yes 

Pricing Details

$65
The pricing is specific to the supported DBMS (e.g., MySQL, PostgreSQL, etc.). Volume discounts available.
Free Trial Yes 
Free Version Yes 

Pricing Details

No price information available.
Free Trial Yes 
Free Version No 

Deployment

Web-Based Yes 
On-Premises No 
iPhone App No 
iPad App No 
Android App No 
Windows Yes 
Mac No 
Linux Yes 
Chromebook No 

Deployment

Web-Based Yes 
On-Premises Yes 
iPhone App No 
iPad App No 
Android App No 
Windows No 
Mac No 
Linux No 
Chromebook No 

Customer Support

Business Hours Yes 
Live Rep (24/7) No 
Online Support Yes 

Customer Support

Business Hours Yes 
Live Rep (24/7) No 
Online Support Yes 

Types of Training

Training Docs Yes 
Webinars No 
Live Training (Online) No 
In Person No 

Types of Training

Training Docs Yes 
Webinars No 
Live Training (Online) No 
In Person No 

Vendor Details

Company Name

KS DB Merge Tools

Founded

2012

Country

Kyrgyz Republic

Website

ksdbmerge.tools

Vendor Details

Company Name

ThorApps

Founded

2012

Country

Australia

Website

www.thorapps.com/project-sync-project-online

Product Features

Database

Backup and Recovery No 
Creation / Development No 
Data Migration Yes 
Data Replication Yes 
Data Search No 
Data Security No 
Database Conversion Yes 
Mobile Access No 
Monitoring No 
NOSQL No 
Performance Analysis No 
Queries No 
Relational Interface No 
Virtualization No 

Relational Database

ACID Compliance No 
Data Failure Recovery No 
Multi-Platform No 
Referential Integrity No 
SQL DDL Support No 
SQL DML Support No 
System Catalog No 
Unicode Support No 

Product Features

Project Management

Agile Methodologies Yes 
Budget Management Yes 
Client Portal No 
Collaboration Tools Yes 
Cost-to-Completion Tracking Yes 
Customizable Templates Yes 
Gantt Charts No 
Idea Management Yes 
Kanban Board No 
Milestone Tracking Yes 
Portfolio Management Yes 
Resource Management Yes 
Time & Expense Tracking Yes 
Traditional Methodologies Yes 

Alternatives

DbSchema Reviews

DbSchema

Wise Coders

Alternatives

Valentina Studio Reviews

Valentina Studio

Paradigma Software
ListSync Reviews

ListSync

ThorApps
Luna Modeler Reviews

Luna Modeler

Ideamerit
CData Sync Reviews

CData Sync

CData Software
FluentBooks Reviews

FluentBooks

FluentPro Software Corporation