SQL Server, SQL Server Express, and SqlDataSource Control

Re: Restore and Backup Facility

Niall20 — Sun, 28 Sep 2008 22:10:18 GMT

Does it support SQL Server 2008?

Re: Restore and Backup Facility

saifxk2 — Mon, 04 Aug 2008 13:04:10 GMT

thank you

Re: Announcing - SQL Server Database Publishing Wizard CTP 1

DBMaster — Mon, 10 Sep 2007 09:00:32 GMT

I tried with SQL 2000 but got an errors.

DBMaster

MyBlog

Re: Announcing - SQL Server Database Publishing Wizard CTP 1

arsalan — Mon, 23 Jul 2007 20:33:52 GMT

Same problem tried with Sql 2000 and failed :(

Re: Announcing - SQL Server Database Publishing Wizard CTP 1

Aleyna — Sun, 03 Jun 2007 12:43:16 GMT

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

Re: Restore and Backup Facility

gburks — Fri, 20 Apr 2007 15:23:52 GMT

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.

Re: Restore and Backup Facility

Motley — Thu, 05 Apr 2007 22:17:22 GMT

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

Re: Restore and Backup Facility

xrock — Sun, 11 Mar 2007 10:32:00 GMT

thank you!

Restore and Backup Facility

SoftMind — Fri, 12 Jan 2007 05:06:27 GMT

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!

Re: Announcing - SQL Server Database Publishing Wizard CTP 1

Liming — Mon, 11 Dec 2006 11:33:48 GMT

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.

Re: Announcing - SQL Server Database Publishing Wizard CTP 1

Nocturnal — Mon, 27 Nov 2006 14:16:50 GMT

I use it with SQL 2000. Did you try and did it not work?

Re: Announcing - SQL Server Database Publishing Wizard CTP 1

Liming — Mon, 27 Nov 2006 07:48:15 GMT

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. :(

Re: Announcing - SQL Server Database Publishing Wizard CTP 1

danwinn — Thu, 16 Nov 2006 19:52:08 GMT

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 at http://www.codeplex.com/sqlhost

Thanks,
Dan

Re: Announcing - SQL Server Database Publishing Wizard CTP 1

Nocturnal — Sun, 29 Oct 2006 04:35:39 GMT

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 :)

Re: Announcing - SQL Server Database Publishing Wizard CTP 1

AMcQ100 — Thu, 19 Oct 2006 10:43:33 GMT

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.