Support MSSQL database about bytebase HOT 6 CLOSED

Hey @bralbral, we have to disappoint you here since MSSQL (as well as Oracle) is not on our roadmap since they both have decent tooling support. For Bytebase, we want to focus on those popular database systems lacking the equivalent tooling support seen in those commercial databases.

Thanks for asking anyway. Feel free to open other issues if needed.

from bytebase.

The databases used in enterprises are becoming more and more diverse, covering MSSQL, MySQL, PostgreSQL, Clickhouse, Greenplum and other databases. Different databases support different applications within the enterprise, which is especially common in non-Internet enterprises such as traditional manufacturing.

There may be tools that support specific databases, but I'd prefer to see a consistent solution. If bytebase can support mssql and orcale, it will gradually become an enterprise-level infra service, standardizing most business development processes. @tianzhou

from bytebase.

@cobolbaby we have to be focused. Onboarding a new database engine is a lot of work. e.g. In order to perform SQL check, we need to first incorporate a parser. For MySQL, we are lucky to have https://github.com/pingcap/parser/, while there is no established one in PostgreSQL, so we may end up building our own.

Backups, DDL changes, user management, schema introspection etc, are all different among different database systems.

from bytebase.

while there is no established one in PostgreSQL, so we may end up building our own

Ref: https://github.com/pganalyze/libpg_query

Onboarding a new database engine is a lot of work

Is there any development documentation for reference?
To extend support for a new database, is it enough to implement the predefined plugin interface?

from bytebase.

Looks like Oracle database support is or may be coming:

• https://github.com/search?q=repo%3Abytebase%2Fbytebase+oracle&type=pullrequests
• https://www.bytebase.com/docs/introduction/supported-databases

from bytebase.

@jhult Right, both MSSQL and Oracle is supported as of 1.15.0

from bytebase.