Multi-User Sync MS SQL Database

Suite and Optimus Suite 5
#1

How can I implement multi-user sync on a MS SQL database.

The guide appears to focus on a MySQL environment:

CREATE TABLE actions_table (
id int(11) NOT NULL AUTO_INCREMENT,
dataId int(11) NOT NULL,
type varchar(255) NOT NULL,
user varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM;

Specific problems with MS SQL / T-SQL:

  • No Auto Increment available for ‘id’ column
  • I am not able to create a column ‘user’

Should I create a second connection to a MySQL database?

Thanks!

#2

The same solution can be used with mssql
SQL dump from existing sample is designed for MySQL but it can be adopted for MsSQL

No Auto Increment available for ‘id’ column
You can define identity for column in question, it will have the same effect as autoincrement in MySQL

id int IDENTITY(1,1),