#PrimaryDatabase. We are on 7.11 cloud and MySQL is the Primary database. We are

sathishkumars over 9 years ago

#PrimaryDatabase. We are on 7.11 cloud and MySQL is the Primary database. We are planning to upgrade to 16.1 soon. 16.1 supports SQL Server as primary database. Can we move our primary database from MySQL to SQLServer ? If yes, will the Appian Product's upgrade team take care of configuring the jdbc drivers, moving the table structures, data, stored proc, views, datastore and entity mappings etc because we are on cloud ? Any other considerations/suggestions on this ?

Discussion posts and replies are publicly visible

Parents

0 Vamsi Sunkara
Appian Employee
over 9 years ago

SQL Server 2014 is indeed supported from 16.1, however, it is not provided on the cloud. If you have a VPN connection setup, you'll be able to integrate it with your Appian instance. (as your business data source, primary still has to be the MySQL that we provide on the cloud)

The second link applies to on-premise customers only. You can integrate any of those databases to your cloud site as additional datasources, just not as the primary.

Perhaps, this link might explain it better,

forum.appian.com/.../Appian_Cloud_Web_Administration.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Vamsi Sunkara
Appian Employee
over 9 years ago

SQL Server 2014 is indeed supported from 16.1, however, it is not provided on the cloud. If you have a VPN connection setup, you'll be able to integrate it with your Appian instance. (as your business data source, primary still has to be the MySQL that we provide on the cloud)

The second link applies to on-premise customers only. You can integrate any of those databases to your cloud site as additional datasources, just not as the primary.

Perhaps, this link might explain it better,

forum.appian.com/.../Appian_Cloud_Web_Administration.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data