Showing posts with label release. Show all posts
Showing posts with label release. Show all posts

Saturday, February 25, 2012

Announcing - SQL Server Database Publishing Wizard CTP 1

The SQL Server group at Microsoft has just launched theSQL Server Hosting Toolkit with the release of theDatabase Publishing Wizard Community Technology Preview 1.

The objective of the SQL Server Hosting Toolkit is to enable a great experience around hosted SQL Server. The Database Publishing Wizard works toward this mission by making it easy to upload a database from a development box up to a shared hoster. In its first incarnation, the Database Publishing Wizard is a command line tool that generates a T-SQL script designed to be executed in the script execution windows provided by most hosters in their database management consoles. In the coming months we'll be adding a GUI and building seamless integration between the tool and an upload service we'll provide to hosters for deployment.

Details on the Database Publishing Wizard as well as the download can be found athttp://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Database%20Publishing%20Wizard.

We plan to be releasing advances in the Toolkit frequently so check out this first CTP and give us your feedback!

Thanks,

Dan Winn

Senior Program Manager, Microsoft SQL Server

Does the SQL Server Hosting Toolkit work alongside Visual Web Developer ?
Will it transfer ASPNETDB.MDF across to a shared SQL 2005 server - without having to write stacks of code ?
Will new ASP users be able to use it ?

Good to see that Microsoft is responding, otherwise you are going to frustrate a lot of VWD newbies ...

Just seen that DiscountASP.NET have a SQL 2005 Attach MDF Tool ... it seems they have recognised that thousands of new VWD user are having real problems moving databases from local to server.

|||

this is a great little tool, thanks for making it available! I've been looking for a utility to pull an image of a hosted database for some time but had no luck finding it. This tool actually works to pull data of a remote SQL 2000 Server.

Whatever you add in the future, please keep the command line available. That will enable this tool for backup purposes.

For a moment I was confused when I could not open the result file in vim. Apparently the format is unicode or whatever 2 byte character encoding is called. I think it would be useful if there was an option to generate plain-simple 1 byte character text files. If only because the size gets cut in half :)

|||

Thanks for your feedback Nocturnal. We'll definitely be keeping the command line. Interesting idea on the single byte text output. The problem would be potential data loss, but we might be able to detect that and throw an error...

By the way, check out the new CTP we just released athttp://www.codeplex.com/sqlhost

Thanks,
Dan

|||darn! a perfect tool for me... only if the source database supports sql server 2000. I'm pushing it the other way around, 2000 to 2005. :(|||I use it with SQL 2000. Did you try and did it not work?|||

Yeah, it didn't.

My source table is 2000, targe is 2000 as well, publish schema only. Get an error while in Gathering list of objects to script. says need 2005 or later. :( had to use the Red Gate sql compare instead.

|||

Very Very Good efforts by the team.

This tools are very much appreciated and welcomed.

I think backup, restore facilities should be included in future versions they are a must. I think dotnet panel is utilising them very smoothly.This could be a disadvantage for users if their host is providing some panels and this is a common scenerio.

----------------------------------------
A little information required here...

What if i upload a new data from my local SQL2005 to remote SQL2005. I just want my local sql2005 to be along with remote sql2005, i do not want to over write the remote sql2005. Is it possible...?

e.g:- my remote has 10 datas. I want to add 2 datas more from my local sql2005 to remote sql2005 to make it 12 datas on remote.
If i over write it will become 2 on remote, i will looose 10 datas.

I hope i have cleared. Thi facility if not added to day, should be considered for future
--------------------------------------------

I was surprised no one has mentioned the links for great tutorials for this tool by Mr. Scott Guthrie.

Any how its here...

Tutorial 1

and

Tutorial 2

Cheers!

|||thank you!|||I would like to be able to select which tables, views, functions, and stored procedures to move.|||

We are currently using the Team Edition for Database Pros plug in for VS Team Suite, along with Web Deployment Projects and Team Build for Team Foundation Server.

Do you think this new utility has a place in that kind of environment? Currently, the database project generates a SQL deployment script when we do a team build, and we can also use the database project's Schema Compare and Data Compare to sync our live databases.

|||;) Good to hear. Very appreciated. I will have a look at it|||

Same problem tried with Sql 2000 and failed :(

|||

I tried with SQL 2000 but got an errors.

DBMaster

MyBlog

Friday, February 24, 2012

Ann:www.SQL-Scripts.Com

Hello,
Announcing the release of a new web site : www.SQL-Scripts.com
At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
different database system. Using our search system you can find scripts
that you need quickly and simply. If you have scripts that you use why not
lodge them on our site. If you lodge your script you could win a prize. In
addition to scripts there are many documents, news feeds and articles.
We have a monthly contest for the first people to lodge 20 scripts in one
month.
Please help to make this site great.
Webmaster at www.SQL-Scripts.com
You are spamming this group. Please cease & desist.
Lots of people manage to get commercial messages expressed by the simple
expedient of placing their URL or service statement in their signature line.
Note that spam messages are not their mode. They get their messages out by
responding intelligently to huge volumes of posts. They really help people
and they're here more to give than to get
HTH
-Larry-
"www.sql-scripts.com" <webmasterNOSPAM@.SQL-SPAM-Scripts.Com> wrote in
message news:udzZVZlJEHA.624@.TK2MSFTNGP11.phx.gbl...
> Hello,
> Announcing the release of a new web site : www.SQL-Scripts.com
> At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
> different database system. Using our search system you can find scripts
> that you need quickly and simply. If you have scripts that you use why
not
> lodge them on our site. If you lodge your script you could win a prize.
In
> addition to scripts there are many documents, news feeds and articles.
> We have a monthly contest for the first people to lodge 20 scripts in one
> month.
> Please help to make this site great.
> Webmaster at www.SQL-Scripts.com
>

Ann:www.SQL-Scripts.Com

Hello,
Announcing the release of a new web site : www.SQL-Scripts.com
At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
different database system. Using our search system you can find scripts
that you need quickly and simply. If you have scripts that you use why not
lodge them on our site. If you lodge your script you could win a prize. In
addition to scripts there are many documents, news feeds and articles.
We have a monthly contest for the first people to lodge 20 scripts in one
month.
Please help to make this site great.
Webmaster at www.SQL-Scripts.com
You are spamming this group. Please cease & desist.
Lots of people manage to get commercial messages expressed by the simple
expedient of placing their URL or service statement in their signature line.
Note that spam messages are not their mode. They get their messages out by
responding intelligently to huge volumes of posts. They really help people
and they're here more to give than to get
HTH
-Larry-
"www.sql-scripts.com" <webmasterNOSPAM@.SQL-SPAM-Scripts.Com> wrote in
message news:udzZVZlJEHA.624@.TK2MSFTNGP11.phx.gbl...
> Hello,
> Announcing the release of a new web site : www.SQL-Scripts.com
> At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
> different database system. Using our search system you can find scripts
> that you need quickly and simply. If you have scripts that you use why
not
> lodge them on our site. If you lodge your script you could win a prize.
In
> addition to scripts there are many documents, news feeds and articles.
> We have a monthly contest for the first people to lodge 20 scripts in one
> month.
> Please help to make this site great.
> Webmaster at www.SQL-Scripts.com
>