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;)
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
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...
thanks!