How do I export settings from the Publish Database Wizard?
I am using the Publish Database Wizard in VS2008 to change the settings of my hosting provider. It doesn't look like these settings come with the project (which is a bit silly for me), but rather come with the machine.
On every new machine I would like to publish, I have to go through the process of fetching my database settings.
Is there a way to backup / export / save these settings to a file?
If so, what is it?
source to share
Hmmm ... it looks like the publish wizard is using 2 config files to configure the application :
The Database Publishing Wizard uses the user.config and hoster.config files to store configuration information. the directory in which these files are stored must have a corresponding NTFS installed file system. These files contain usernames and encrypted passwords. Passwords are encrypted using DPAPI.
user.config file
This file stores the saved hosts and configuration settings for publishing the Database Master. The user.config file is located in the% SystemDrive% \ Documents folder and Settings \% Username% \ Application Data \ Microsoft \ Microsoft SQL Server \ 90 \ Tools \ Publishing Wizard \ user.config.
hoster.config file
This file stores Internet options, service addresses, usernames, and databases for shared hosting providers. The hoster.config file is located in the% SystemDrive% \ Documents and Settings \% Username% \ Application Data \ Microsoft \ Microsoft SQL Server \ 90 \ Tools \ Publishing Wizard \ hoster.config folder.
I'm trying to access these files on Vista (with VS2008 and SQL Express installed) and blow. I'll keep you up to date.
Update: Looks like I didn't have the publish wizard installed. By selecting the version for VS2008 here and then installing (and don't worry - you won't see any of the directions it installed, but it does) .... and THEN, setting up my first database with the wizard, it looks like there really are some settings that are stored in the "Application Data Directory" above. However, it looks like user.config and then an XML file for each configured database. I believe you can copy each of these files for later use.
source to share