Page 1 of 1

Location of Folder "Sql Templates"

Posted: Fri 21 Sep 2012 09:07
by michabbb
dear support,

i would like to share my snippets/templates with dropbox, is there an option to set the path of "Sql Templates" somewhere in dbforge ?? or how can i do this ?

thank you,
micha

Re: Location of Folder "Sql Templates"

Posted: Fri 21 Sep 2012 10:39
by alexa
You can put your snippets into the \Sql Templates\ folder that is located in the installation folder of dbForge Studio for MySQL or you can create a sub-folder with your snippets.

Re: Location of Folder "Sql Templates"

Posted: Fri 21 Sep 2012 10:46
by michabbb
dear alexa,

the current folder is:
C:\Program Files (x86)\Devart\dbForge Studio for MySQL\Sql Templates

i want: Q:\dropbox\Sql Templates

how i can realize this ?

regards,
micha

Re: Location of Folder "Sql Templates"

Posted: Fri 21 Sep 2012 12:11
by alexa
Please do the following:

1. Open the the registry editor.
2. Select the 'HKEY_LOCAL_MACHINE\SOFTWARE\Devart\dbForge Studio for Oracle\CodeSnippets\Oracle' branch.
3. Change the value data of the 'DirectoryPath' value.

Re: Location of Folder "Sql Templates"

Posted: Fri 21 Sep 2012 13:19
by michabbb
thank you, i only see these entries at

HKEY_CURRENT_USER\Software\Devart\dbForge Studio for MySQL\Folders

(you wrote something about oracle;)

Image

shall i create "DirectoryPath" here ?

Re: Location of Folder "Sql Templates"

Posted: Fri 21 Sep 2012 13:35
by alexa
Sorry, the provided solution was for dbForge Studio for Oracle.

If you are using dbForge Studio for MySQL, please follow the steps:

1. Open the the registry editor.
2. Select the 'HKEY_LOCAL_MACHINE\SOFTWARE\Devart\dbForge Studio for MySQL\CodeTemplates\MySQL' branch.
3. Change the value data of the 'RootDirectory' value.

Please also make sure you are using HKEY_LOCAL_MACHINE, but not HKEY_CURRENT_USER.

Re: Location of Folder "Sql Templates"

Posted: Fri 21 Sep 2012 13:42
by michabbb
i have to verify, sorry: do i change the whole path of the program with this key
(C:\Program Files (x86)\Devart\dbForge Studio for MySQL\) or only the path:
C:\Program Files (x86)\Devart\dbForge Studio for MySQL\Sql Templates

thank you!

Re: Location of Folder "Sql Templates"

Posted: Fri 21 Sep 2012 14:01
by alexa
You would need to set 'RootDirectory' to 'Q:\dropbox\Sql Templates'

Re: Location of Folder "Sql Templates"

Posted: Wed 03 Sep 2014 22:16
by michabbb
hi,

after every update, the registry value gets overwritten ;-((

HKEY_LOCAL_MACHINE\SOFTWARE\Devart\dbForge Studio for MySQL\CodeSnippets\MySql\DirectoryPath

please don“t touch this while running updates, that is very annoying :evil:

thanks!

Re: Location of Folder "Sql Templates"

Posted: Thu 04 Sep 2014 09:57
by alexa
This can be avoided by installing a new build on top of the older one rather than uninstalling/installing.

Re: Location of Folder "Sql Templates"

Posted: Thu 04 Sep 2014 10:05
by michabbb
i use the regular update feature.
i download it, it restart dbforge, than i get the info, that a new version is there and i get asked to update and follow there regular procedure.
what do i have to change ?

Re: Location of Folder "Sql Templates"

Posted: Thu 04 Sep 2014 11:25
by alexa
Sorry for the confusion. This appears to be the service directory of dbForge that gets updated in anyway.

Re: Location of Folder "Sql Templates"

Posted: Thu 04 Sep 2014 13:07
by michabbb
yes i know.. thats why i made my posting...
and i please you to NOT UPDATE this VALUE in the registry so that we keep our own directory for the snippets and dont have to fix this after every update... :x

thanks!