search

hankinsoft / SQLPro

SQLPro bug & features tracking.
104 stars 27 forks source link

Export settings/connections #146

Open cafferata opened 7 years ago

cafferata commented 7 years ago

Is there an settings/connections file located on disk? And is there an export functionality on the roadmap of SQLPro?

cc: @rogierlommers https://github.com/hankinsoft/SQLPro/issues/27

hankinsoft commented 6 years ago

No option to export at the moment. I've been working on iCloud sync for an upcoming version, but I'll add an export/import option soon as well.

cafferata commented 6 years ago

Hi @hankinsoft, any news on this issue? Can you tell me what is the best way to keep up to date with the development changelog? I searched online; on Github, on the SQLPro Studio website, on setapp.com. In addition, within the application itself in the places 'About' and 'Help'. All without success.

hankinsoft commented 6 years ago

Hi, the iCloud sync feature currently works for MySQL & MSSQL but unfortunately not on SetApp as of yet. I don't currently post a changelog other than via the Mac App Store. I've been working on a few changes that will have it in setapp within a few versions as well, but not quite yet.

cafferata commented 6 years ago

Thanks for your quick response! I had not thought about the Mac App Store myself.

A bit off topic; is it an idea to place the release notes (also) online and to link them in from the different applications? You can reuse the data from Mac App Store release notes:

mac-app-store-release-notes https://itunes.apple.com/nl/app/sqlpro-studio/id985614903?dataOnly=true&isWebExpV2=true

Perhaps I can do something for you here?

hankinsoft commented 5 years ago

Hi, just wanted to note that all version of SQLPro (including Setapp) have been synching through iCloud for awhile now. Does anyone still require an export option for connections and if so, could you please provide the use case?

cafferata commented 5 years ago

Sorry, I missed your comment. For use (@jcid) it makes scene to maintain the connection settings in a central system/intranet. So for Sequel Pro we simply import de database settings from an exported file from our intranet. I was hoping doing the same with SQLPro without setting up an shared iCloud sync between myself and colleagues.

primordius commented 4 years ago

I keep looking for this feature from time to time. It's something I'd like for my team.

jfbloom22 commented 4 years ago

I am using SQLPRO for MSSQL downloaded from the website. Moved to a new computer and now trying to figure out where my list of connections lives on disk so that I can copy it over. I don't need a new feature, I just need help finding the file so that I can copy it over.

Also, if you know where the file is, why not move it to Dropbox and create a symbolic link in the original location?

hankinsoft commented 4 years ago

@jfbloom22 unfortunately export/import is still unavailable. The connections themselves are not stored on the file system, but in the iCloud Keychain. If you are signed into the iCloud Keychain on both devices your connections will automatically appear/sync between both systems.

jfbloom22 commented 4 years ago

Ah ok cool. I'll see if I can export it out of my Keychain since I don't use iCloud Keychain. Thanks for the help!

Random thought: I am encouraged that this is stored securely in Keychain. I wonder if it would be easier for the export/import functionality if only the password was stored in the Keychain. I would expect an export from the GUI would not include the password anyway.

jfbloom22 commented 4 years ago

I ended up temporarily turning on iCloud Keychain and my list of connections synced over to my new Mac. Very pleased! When iCloud Keychain is enabled, this is almost magical.

jeisaacs commented 1 year ago

Thanks @hankinsoft - is there a way to clear the iCloud sync manually, as mine doesn’t seem to be saving updated IP addresses for connections and keeps loading the old ones :(

hankinsoft commented 1 year ago

Still planned and partially implemented. Still no ETA.

eduardogd commented 6 months ago

I have a password stored, is it possible to view it?

hankinsoft commented 6 months ago

Hi, The only current way would be to use the following steps:

  1. Open Keychain Access
  2. Search for RecentConnection. You will find a bunch of entries related to SQLPro, one for each type of database (mysql, Postgres, mssql, etc).
  3. Open the entry which relates to your database type and click the show password checkmark.
  4. You will be prompted for your system password. Enter it and hit accept.
  5. Now the password field will show probably a [ which is the start of a json entry. Select the field and select all via cmd + a. Copy the text out and into a text editor.
  6. Your password will be one of the json entries.
eduardogd commented 6 months ago

Hi, The only current way would be to use the following steps:

  1. Open Keychain Access
  2. Search for RecentConnection. You will find a bunch of entries related to SQLPro, one for each type of database (mysql, Postgres, mssql, etc).
  3. Open the entry which relates to your database type and click the show password checkmark.
  4. You will be prompted for your system password. Enter it and hit accept.
  5. Now the password field will show probably a [ which is the start of a json entry. Select the field and select all via cmd + a. Copy the text out and into a text editor.
  6. Your password will be one of the json entries.

Perfect! I've never think it was a JSON file. Works like a charm!