I’m working on a project where I need to replicate the table structure from an Oracle to SQL Server but without transferring any data. Essentially, I want to:
-
Read tables from Oracle, recreate the same tables in SQL Server and write only the schema (field names, data types), not the records
-
-
Is there a best practice to force FME to write only the schema?
-
Are there limitations I should be aware of (e.g. no support for constraints, indexes)?