Hello,
I am new to Hackolade. I'm willing to export un model for SQL Server but the order of tables in the DDL file is not working well. For exemple, one table is created with foreign keys but which are in others tables not yet created.
So, if there is a solution to this problem ? or is there a place where I can choose the order to create the tables ? Thank you in advance !
Sure, you may change the order of the tables in the Object Browser on the left, by clicking on a table, then using the Up or Down arrow buttons in the toolbar. This will affect the order of the tables in the DDL script.
It works. Thanks:)
Hello,
During my use of DDL for SQL Server exported directly from Hackolade, I found that there is a problem with the statement "GO". It did not work well for me because of the lack of a line-break before some "GO" . In fact, in the DDL script, for some "GO", there is a line-break, but not for each one.
We want to use it more automatically. Is there a solution to this ? Or should I need to change the settings for a line-break before each "GO" ?
Thanks a lot for your reply in advance :)
Hi. When you say that there is a problem, can describe in more details? What is the tool you're using to apply the DDL? Can you share screenshots of the error messages? etc...
Can you also explain what you mean with "use it more automatically?" Thanks
Hello. I used SQL Server Management Studio 2019 to apply the DDL.
The error shows as following :
When I add an Enter before each "GO", it works.
I wonder if there is a solution so that we don't need to make any change in the DDL file before it's used. I called this more automatically.
Thank you so much.
Thanks for the info. Let me check with the developers, and I'll get back to you.
We have added the possibility to choose the batch separator for DDLs, either a semi-column (default) or GO. This is available both in the UI and in the CLI, starting with version 4.1.8
I have tested, it works well.
Thanks a lot :)