dbForge MSSQL dbQuery: sql.design not loading

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
itdev1980
Posts: 1
Joined: Mon 14 Mar 2022 18:38

dbForge MSSQL dbQuery: sql.design not loading

Post by itdev1980 » Mon 14 Mar 2022 18:47

- 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.

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: dbForge MSSQL dbQuery: sql.design not loading

Post by .jp » Tue 15 Mar 2022 07:43

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.

Post Reply