Location of Folder "Sql Templates"

[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

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

[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

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

[michabbb]

thank you, i only see these entries at

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

(you wrote something about oracle;)



shall i create "DirectoryPath" here ?

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

[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!

[alexa]

You would need to set 'RootDirectory' to 'Q:\dropbox\Sql Templates'

[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

thanks!

[alexa]

This can be avoided by installing a new build on top of the older one rather than uninstalling/installing.

[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 ?

[alexa]

Sorry for the confusion. This appears to be the service directory of dbForge that gets updated in anyway.

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

thanks!