You broke the import from SQL Server script. It doesn’t connect tables anymore. And also “Indexes” section does not wrap names in quotes so it also doesn’t work.
Can you give us some error example scripts so we can procedure more accurately?
Thank you for your report! We will immediately look into this issue.
For the indexes :
When you add indexes like this and export for SQL Server, error occurs when import the .sql
Indexes {
(prop1, prop2) [unique]
}
" Incorrect syntax near ‘myColumn’ "
in the .sql generated the line is
CREATE UNIQUE INDEX [index_name] ON [table_name] ("prop1", "prop2")
GO
and it should be
CREATE UNIQUE INDEX [index_name] ON [table_name] ([prop1], [prop2])
GO
note the bracket [ ] around the property
ps ( we actually can’t create post => An error occurred: You are not permitted to view the requested resource. )
Hi @Matteo_Convert , I tested this with MSSQL 2022, and the database did not raise any errors. It looks like the version you’re using may not support this syntax for indexes. Could you let me know which MSSQL version you’re using?
It’s because it’s SQL server not MySQL
Hi @Matteo_Convert,
Sorry for the confusion. The database I referred to was Microsoft SQL Server, and I used the 2022 version for testing. The issue you’re experiencing might be related to an older version. Could you let us know which SQL Server version you’re using so we can assist you further?
i’m using 2022 too but i use the sqlcmd command who raise the error
it appear with SSMS (SQL Server Managment Studio ) to