|
Sponsored Links
Resources
.NET Research Library
Get .NET related white papers, case studies and webcasts
|
News
News
News
|
Messages: 6
Messages: 6
Messages: 6
Printer friendly
Printer friendly
Printer friendly
Post reply
Post reply
Post reply
XML
XML
XML
|
 |
Red Gate releases SQL Packager, a SQL Server deployment tool
Red Gate Software, makers of "simple tools for Microsoft technology developers and DBAs", has released a new product called SQL Packager, a utility for packaging SQL Server database instances as executables for easy deployment to local or remote sites.
From the press release,SQL Packager guides users through four basic steps:
- deciding on the schema and data to be packaged;
- scripting schema and data to preserve dependencies;
- packaging as an executable or as a .NET project; and
- creating a utility for easy installation by administrators or customers.
The package is available for 14-day trial download; see Red Gate's home page for details.
|
|
|
Message #127811
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Red Gate releases SQL Packager, a SQL Server deployment tool
While I think this is great and a wonderful tool, I'm curious to understand what everyone's perspective and experiences have been in developing a successful CM environment, promotion schema for their database environments.
I developed in conjunction with a client a tool that does something similar by gathering difference images from Source Control providers. It allowed for generating deployable "roll-up" patches. My goal is to stabilize it, create some NAnt and MSBuild tasks and release it open-source, but I would hope that we weren't the first to attempt this.
The gap I continue to see with this tool is that you STILL have to maintain a master database disconnected from a source control environment. That is, there is no clean promotion schema from development, to source control to master environment. I am not a dba or db developer by trade, but I am and have been lead release manager for application development and I'd like to think the same processes can be applied.
What are your thoughts.
|
|
|
Message #127812
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Red Gate releases SQL Packager, a SQL Server deployment tool
Man - I'm not much for grammar, am I?
|
|
|
Message #127873
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Red Gate releases SQL Packager, a SQL Server deployment tool
I like it... it produced a very simple setup program, and the C# source code to build it!
However, my current solution, which is a batch file calling a few osql command line statements is also fairly simple.
That said, customers and implementors are more confidant with a simple GUI application, so we may well go for this.
|
|
|
Message #127896
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Red Gate releases SQL Packager, a SQL Server deployment tool
You should check out www.dbghost.com which intergrates with your Source Control system either implicitly (VSS) or explicitly (all others). It does what you say you are developing. We too believe this is true change management, everything else is missing the points fundamental to change control. Creating the delta is only one part of the process - we believe we have the only tool that covers database change management for SQL Server. And its getting better and better with an SDK due for release in August.
regards,
Mark Baekdal
www.dbghost.com
True database change management for SQL Server.
|
|
|
Message #127957
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Red Gate releases SQL Packager, a SQL Server deployment tool
Ironically - we included your product in a review of the products for the company I currently work for. They will not be using the product I'm completeing, because it's not ready yet.
I'll let you know how it turns out.
|
|
|
Message #127972
Post reply
Post reply
Post reply
Go to top
Go to top
Go to top
|
|
Red Gate releases SQL Packager, a SQL Server deployment tool
Superb tool - This is the quickest way to recreate a database/take a copy of a database (including data) and saves time and worry over recreating the db correctly with data.
Highly recommend trying it out as you end up with an exe that you can run very easily to recreate the database with the same name or a new/similar name.
5 out of 5 and gets the thumbs up from me.
Cheers
Gregor Suttie
|
|
|
| |
|
| New content on TheServerSide.NETNew content on TheServerSide.NETNew content on TheServerSide.NET |
|
|
Language "mashups" will become more prominent, and developers will become polyglots, one programmer suggests.
SearchWinDevelopment.com offers an introduction to the language, performance, testing and data management improvements in VS 2008.
VBCode.com code snippets cover all aspects of application development, from data binding to security to the user interface.
Get up to date on XAML best practices with a variety of articles, tutorials and webcasts. [SearchWinDevelopment.com]
One team's experience with the VSTS DB edition suggests that it can improve workflow for dev teams. It also enhanced Agile efforts.
(June 24, Article)
Microsoft has begun to include DSL tools in the VSTS kit. A new book by Steve Cook and other VSTS team members helps set the stage.
(June 24, Article)
Cartoon: Be it ever so humble there is no place like your home after you get a Microsoft Home Server .
(June 18, Cartoon)
Microsoft's Thom Robbins says new technology to highlight in NET 3.5 includes AJAX, LINQ for both C# and VB, as well as tooling enhancements intended to ease the task of building WPF, WF and WCF apps.
(June 29, Podcast)
Venkat Subramaniam discusses AJAX bottlenecks, the tenets of Agile development and more. He spoke at the Ajax Experience.
(June 25, Tech Talk)
In the second of a two-part series, Michele Leroux Bustamente discusses design decisions related to the claims-based security model. Read the story and walk through the process for creating a set of claims-based utilities to encapsulate claims authorization at the service tier.
(May 24, Article)
Understanding why the Entity Framework exists and learning where it can fit into your projects can get you prepared for the eventual release early next year.
(May 10, Article)
Resource: This learning guide gives you quick access to useful links on Windows Communication Foundation security information.
(April 24, Article)
TSS.NET's Jack Vaughan spoke recently spoke with Microsoft's Brad Abrams to find out what he is seeing in the field and what the chefs in Redmond are cooking. Along the way he discusses patterns of AJAX frameworks.
(April 11, Article)
In a two-part series, Michele Leroux Bustamente explains how claims-based security is supported by WCF, and how you can implement a claims-based security model for your services.
(March 29, Article)
Windows Workflow Foundation is a new technology that many developers will need to get their heads around. In a brief excerpt adapted from Programming Windows Workflow Foundation: Practical WF Techniques and Examples using XAML and C#, K.Scott Allen considers aspects of workflow definition.
(March 22, Chapter Excerpt)
|
|
