Page 1 of 1

.Design files

Posted: Thu 14 Mar 2013 11:08
by Valgardur
How can I prevent dbForge from creating .design files? My folders are constantly being "littered" with these files...

Re: .Design files

Posted: Thu 14 Mar 2013 17:09
by alexa
You can not prevent dbForge from creating .design files. These files contain parameters, the design of Query Builder diagrams, pivot tables, and other parts of complex SQL documents. This file is not created when you work just with the plain text of a query, but is created when you change a document's settings or start working with different views of the document. If you delete this file, you will only loose the values of the parameters, layout, some other characteristics of the Query Builder diagrams, or pivot table settings which can be always redefined at a later time. However, if you keep the file, all the settings can be used in the later sessions of the application.

Re: .Design files

Posted: Fri 15 Mar 2013 10:10
by Valgardur
Actually, if I enter one SQL statement, execute and save as a ".sql" file (select * from mytable) an ".design" is created.

Would it be possible to save them in a separate folder?

And only created when necessary?

Re: .Design files

Posted: Fri 15 Mar 2013 11:18
by alexa
This happens because when you execute the script, the new 'Data' view gets activated which means that you have started working with different views of the document and, as a result, the .design file gets created.

Unfortunately, this is not possible to save a .design file in a separate folder.

Re: .Design files

Posted: Sat 04 Jan 2020 05:52
by ahdung
stupid design, you should allow users to turn off it at least, I don't care what's your parameters, diagrams balabala, I just care my .sql.
I JUST CARE MY sql!!!
I JUST CARE MY sql!!!

Re: .Design files

Posted: Tue 07 Jan 2020 14:26
by alexa
To avoid this, you have to create a SQL document by clicking 'New SQL' rather than 'New Query' and don't use the 'Query Builder' tab.

Re: .Design files

Posted: Mon 03 Feb 2020 00:57
by mpalmer
I agree it's very annoying - I constantly delete the .design files. I never use the Query Builder

Re: .Design files

Posted: Mon 03 Feb 2020 15:20
by alexa
Could you please provide us a video demonstrating this issue?

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .