Red Gate forums :: View topic - Strategy for applications that have config data in the db
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control EAP
SQL Source Control EAP forum

Strategy for applications that have config data in the db

Search in SQL Source Control EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
neilx



Joined: 20 Apr 2007
Posts: 8

PostPosted: Thu Jun 03, 2010 12:30 pm    Post subject: Strategy for applications that have config data in the db Reply with quote

SQL Source Control has been working really welll for me so far on my main database.

I wonder if you have any advice on a strategy for versioning a website that stores essential config settings in a dedicated database? I am using Dotnetnuke (DNN).

In order to check out a working current version of a DNN site, I need the files and db schema (no problem) plus the data in the tables that drive the site (aspmembership, tabs, modules, portals etc).

It would be really good to check out an svn project for the latest version of the site then build it locally (I would need to create an ms-build script), make changes then commit and deploy to the production site automatically (with CI).
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Thu Jun 03, 2010 1:12 pm    Post subject: Reply with quote

The only advice I can give you is to try it and let us know if you come across any hurdles. If you have config data that you want to store alongside your source controlled schema, you can achieve this using SQL Data Compare Pro. This is described here:

Source control static data using SQL Data Compare Pro

Deployment is achieved using a combination of SQL Compare Pro and SQL Data Compare Pro, or you can build it into your build process.

Automate your database builds using SQL Compare Pro and SQL Data Compare Pro

If you hit any issues, we'll be happy to discuss these with you. What you describe is exactly the problem we are attempting to solve in this tool.

Kind regards,

David Atkinson
Product Manager
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group