SQL Server Hosting Toolkit

Fantastic tool thanks. I am hoping to install using OSQL from my intaller package. The select objects I agree is cool. Maybe an option to exclude EXECUTE AS OWNER objects such as database diagram functions might be nice. Good work. Cheers. Steve.

Great tool I have been looking for this kind of tool. It works great Thanks

Are there plans to make the source code of the Database Publishing Wizard available?

It would be nice to have a feature where we can save our selection of database objects or have the ability to load this list from a text file. I usually have a list of database objects which i need to deploy from different databases and it is a pain to select every object everytime i want to deploy my database objects.

I am new to this, and am trying to upload my database to a hosting server. Is there anyone who'd be willing to help me sort out what "web services address" means? Thanks

Hi Mick,

The web service address would be the url where your hosting service provider has deployed the Database Publishing Services component. You should contact your hosting service provider to get this address.

Thanks

Great tool. One problem though that drove me nuts - the script file that is produced comes out as unicode text, and when you run it you get an erro. The solution is to load it into Windows Notepad and then save it selecting the ANSI text option.

Same problem here: I use an .aspx page to run the generated script, but that gives an error (System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '?'). Saving the file in the ANSI-format solves this issue. Great toolkit anyway!

I love this tool. The only thing I can think to add would be to have an "Update" option. This would include "ALTER" statements to the SCHEMA, allowing updates to be easily propagated to the database without affecting the current data already in there. (Obviously assuming you are only adding something or changing something that does not affect the data)

Hi I Have A problem In My Web Application as The Database becomes Readonly After Some Time On The Webserver and Then I Need To Wait Till The Session Expires and then it Will Work For Some Time And Then Same Thing Happens Again BUt It Works Fine On The Local Server
I Have Used Access And DataReader For Retrieving The Information

I didn't see an answer to @willsllc's question, so I'll ask again. Are there plans to release the entire source code for this project? After all, isn't this the intent of CodePlex?

I'm new and looking around. I have a small internet service, IIS etc. and MsSql 2005. I would like to get a couple of tables on the web, that is a call to http:\\<my site> &123 would bring up to the site for all to see,
select * from <my table> where ID=123
I'd like some columns to be read only and others to be read write.
Can this be done??? is this the right forum

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 dependancy 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 http://www.xsqlsoftware.com/Product/Sql_Database_Deployment_Builder.aspx. 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.