I wish to install a SQL server DB on a VM already running a SQL anywhere DB.
May I encounter a compatibility issue ?
Sql-server – SQL Server and SQL anywhere compatbility
sql serversybase-sql-anywhere
Related Question
- Shrink a SQL Anywhere 12 database
- Sql-server – SQL Server compatibility level
- Sql-server – How data can be transferred from Sybase SQL Anywhere to SQL Server
- SQL Anywhere 12 – Exporting Data to Excel
- How to view a list of databases under server in SQL Anywhere like we do in SQL Server
- SQL Anywhere Long Varchar/Binary Column Length Limited to 32767
- SQL Anywhere 17 – Database Server Connection Limit Exceeded
Best Answer
There's no reason why you should have a problem running SQL Anywhere and SQL Server on the same machine - so long as you have the appropriate resources to meet the needs of both. That will depend entirely on how busy the various databases are. We have many machines running both.
NB There is no connection between the code bases of SQL Anywhere and SQL Server. SQL Anywhere is a development of WATCOM SQL and although it was owned by Sybase and now SAP, it is an entirely separate product from Sybase (now SAP) ASE - Adaptive Server Enterprise, which did originally have a common origin with MS SQL Server.
If you run into any problems it might be worth posting on http://sqlanywhere-forum.sap.com/questions/ which is a specialist SQL Anywhere forum.