score:1
I don't know of an automated way to do it, but it shouldn't be too hard. If it were my, I'd just submit my SQL Server or Oracle DDL to a test Derby database and start looking at the errors.
Then I'd start writing a short program in my favorite scripting language to process the DDL and change the parts that Derby is complaining about to the syntax that Derby requires.
score:1
Have a look at Liquibase.
You can define your tables (and other DB objects) in a DBMS independent XML definition. Liquibase will then take care of creating the approriate DBMS-specific DDL for you.
If you need to target different DBMS with the same definition source, this is definitely something you should look at.
More questions
- Converting Oracle or Sql Server DDL to Derby
- Converting data types from Oracle to SQL Server in an ASP.NET project
- Converting Cursor statement from SQL Server to Oracle doesn't work
- Converting SQL Server to Oracle
- Converting MySQL DDL to SQL Server DDL
- Converting an Oracle trigger to a SQL Server trigger
- Converting Pivot from Oracle to SQL Server
- Converting Oracle code to SQL Server for a fixture list
- Converting Sql Server If not exists to Oracle
- Converting SQL Server to Oracle
- converting sql server query to oracle outer join issue
- Converting SQL Server date to Oracle
- Converting Select results into Insert script - SQL Server
- Why SQL Server throws Arithmetic overflow error converting int to data type numeric?
- MySQL vs. SQL Server vs. Oracle
- SQL Server : Arithmetic overflow error converting expression to data type int
- SQL Server converting varbinary to string
- Simulation of CONNECT BY PRIOR of Oracle in SQL Server
- SQL Server : converting varchar to INT
- SQL Server VS Oracle
- Oracle SYS_CONNECT_BY_PATH equivalent query into SQL Server
- SQL Server : error converting data type varchar to numeric
- Converting SQL Server varBinary data into string C#
- How do you setup a linked server to an Oracle database on SQL 2000/2005?
- Entity Framework 5 mixing Oracle & SQL Server
- Oracle considers empty strings to be NULL while SQL Server does not - how is this best handled?
- SQL Server : RowVersion equivalent in Oracle
- Is it against license to publish Oracle and SQL Server performance test?
- converting sql server rowversion to long or ulong?
- Connecting to Oracle Database using Sql Server Integration Services
More questions with similar tag
- SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904)
- What do the quotes mean in this SQL Server snippet? (SELECT '' column1, '' column 2)
- Entity Framework Multi Table Relation
- Table Variables with an Alias in a Delete From Statement
- Change a field when select
- Can I recover international characters mistakenly stored in a varchar field?
- Matching primary key and foreign key value
- SQL - Display Name ID from Consecutive Occurrences of values in a Table
- SQL Error - The multi-part identifier "CF.OBJ" could not be bound
- How can I make Sum() return 0 instead of 'null'?
- SQL Server - multiple counts in one query results issue
- Returning the closest to a date in a table using PDO Mysql/MSSQL
- SQL same column name allowed
- Working in MY SQL but not in MS SQL Server or ORACLE
- sql server 2012 - check constraint
- How can I avoid calling a stored procedure from a UDF in SQL Server
- Select Distinct Sum SQL Server
- SQL Server system procedure 'sp_replmonitorrefreshjob'
- Connect to SQL Server 2017 using hibernate
- Cumulative distinct count filtered by last value - T-SQL
- Can a SqlServer trigger push to ActiveMQ
- Does SQL Server 2017 Standard support parallel processing in SSAS?
- Error in backing up database
- How to use table values as parameters in stored procedure?
- Group Consecutive Records
- SQL Server - Best practice to circumvent large IN (...) clause (>40000 items)
- how to perform sorting and filtering in stored procedure with performance optimization?
- help in solving a problem in sql server
- SSIS Package last run date in a variable
- SQL INSERT for multiple tables