Devart Forums

- How do I open a saved sql.design file in the DevArt MSSQL suite?

I am using the evaluation version of dbForge Query builder for MSSQL

dbQuery is not opening the sql.design files. I am loosing the diagrams I am laying out. The program seems to be saving the sql.design file, but is unable to open it.

The DB has 1020 tables and ~17k columns. I'm testing on my Dev.

The diagram is obviously very large. It's something I need dbQuery to load and save. I don't mind the wait for it to load. However, I think it's rescanning my 1020 table structure every time and rebuilding from scratch.

Hello,

Thanks for the post.

When you save a query designed in the query builder any dbforge tool saves two files: a query file (*.sql) and a query properties file (*.sql.design). There is no need to open the query properties file, just open SQL file and all diagram properties from the design file will be applied.

Best Regards.