Versions Compared

Version Old Version 2 New Version 3
Changes made by

Lindsey Byers (Deactivated)

Lindsey Byers (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Align
aligncenter

     Content Without Boundaries





Summary

SkySync supports SQL Server, PostgreSQL, Oracle, and MySQL databases. For complex database scenarios, SkySync allows you to supply the connection string with the applicable options and format necessary for your database environment. However, these connection strings can be modified with additional platform parameters and values. See below for examples


Image Added


This page is in-design. It will be updated by January 25, 2019

Contact Support if you need further assistance
Panel
bgColor#FFFACD

If connectivity to the database cannot be made with default database configuration options, it may be necessary to utilize the connection string to specify the correct parameters.

  • As an example, it is a common enterprise practice to change the default SQL Server port from 1433 to another port; therefore, requiring the use of a connection string


Table of Contents



SQL Server Connection Strings


Code Block
titleSQL Server | Integrated Authentication (Windows Authentication)
Server=MySqlServer;Database=SkySyncV4;Integrated Security=true


Code Block
titleSQL Server | Use Specific Credentials (SQL Authentication)
Server=MySqlServer;Database=SkySyncV4;User ID=myUsername;Password=MyPassword


Code Block
titleSQL Server | Always On - Availability Group Listener with Multi-Subnet
Server=tcp:MyAGListener,1433;Database=SkySyncV4;IntegratedSecurity=SSPI;MultiSubnetFailover=True


Code Block
titleAzure SQL DB Standard Connection
Server=tcp:[serverName].database.windows.net;Database=SkySyncV4;User ID=[LoginForDb]@[serverName];Password=myPassword;Trusted_Connection=False;Encrypt=True




PostgreSQL Connection Strings


Code Block
titlePostgreSQL Standard Connection
dbProvider=npgsql,dbConnectionString=User ID=myPostgreSqlUser;Password=MyPassword;Host=myServerName;Port=5432;Database=SkySyncV4




Oracle Connection Strings


Code Block
titleOracle | Integrated Authentication (Windows Authentication)
Data Source=MyOracleServer;Integrated Security=yes




MySQL Connection Strings


Code Block
titleMySQL Standard Connection
Server=MySqlServer;Database=SkySyncV4;Uid=SkySyncUser;Pwd=MyPassword