Malisa Ncube - .NET Delights

.NET Development ideas and things
posts - 41 , comments - 84 , trackbacks - 0

My Links

News



I LOVE DataObject.NET
http://xceed.com
http://www.sharpcrafters.com/
http://www.telerik.com

Get this blog as a slideshow!
Powered by feedmap.net

Twitter












Tag Cloud

Archives

Post Categories

Deploying SQL Server Databases


The Database Publishing Wizard (http://www.codeplex.com/sqlhost)

I think there is a lot of work that needs to be done in this tool. I will include the a few list of items below.

1. Versioning. There is no versioning functionality that will check to see differences between the target database and the deployment database.

2. Partitioning Data. There is no way of selecting "system" data (data required for the application to work. e.g. administrator account). The developer may need to only include sample data or have an option of excluding sample data.

3. Encrypted Objects. How does the publishing wizard behave on encrypted stored procedures and Views?

4. UDFs. The User defined functions are not published.

5. Dependency Checks. There is no dependency checking, which results in a script which may not run because parent objects have not been created yet.

I'm still trying to find the best way to deploy a database. I stumbled upon a tool called xSQL Builder from www.xsqlsoftware.com Interesting, but costs $599.

Some of the clues, that seem very good from the xSQL Builder are that

1. It uses "backup" and "restore to target" which means it would be able to deploy all database objects.

I therefore think that the best way is to use the traditional backup/restore or the detach/attach and post-tasks will be for upgrade scripts or sample data.

It would be nice to have a single output executable file (maybe .cmd) which can accept arguments and install either sample or system data and upgrade schema if necessary.

Print | posted on Tuesday, April 22, 2008 3:24 AM |

Feedback

Gravatar

# re: Deploying SQL Server Databases

Hi There

May I point you in the direction of http://www.red-gate.com and take a look at SQL Compare and SQL Packager - both of these come within SQL Toolkit and you can even get a fully functioning Free 14 day trial - SQL packager sounds like your bets bet.

Cheers
Gregor
4/22/2008 5:28 AM | Gregor Suttie
Gravatar

# re: Deploying SQL Server Databases

Hi Gregor

I had a look a the RedGate tool and another one from SSW
(www.ssw.com.au/SSW/SQLDeploy). SQL packager has the following disadvantages.

1. Other database objects, like the UDFs, Stored procedures and views, are they packaged? What if they are encrypted?
2. The cost

Regards
Malisa

4/22/2008 5:53 AM | Malisa Ncube
Post A Comment
Title:
Name:
Email:
Comment:
Verification:
 
 

Powered by: