Conversion of SQL Server DDL to databricks ddl
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2024 04:12 AM
Hello All,
I want some tool which can be used in Databricks to convert my SQL Server DDL to my databricks DDL ,
For example,
I have one DDL in SQL Server as below,
CREATE TABLE [schema1].[table_1]
(
[BranchKey] [int] NOT NULL,
[Branch Code1] [int] NULL,
[Zone] [varchar](255) NULL,
[Region] [varchar](255) NULL,
[Br_Open_Date] [datetime] NULL,
[ZO_Banca_Manager_ECN] [int] NULL,
[ZO_Banca_Manager_Name] [varchar](255) NULL
)
WITH
(
DISTRIBUTION = ROUND_ROBIN,
CLUSTERED COLUMNSTORE INDEX
)
Now I don't want to write any code manually to change compatible datatypes to covert above sql server ddl to databricks
Please help me to find some tool which allows me to convert this without any manual efforts.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2024 04:31 AM
Accelerates migrations to Databricks by automating code conversion and migration validation - databrickslabs/remorph

