SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Are there tools for automating of SQL Databases and Applications deployment?


Are there tools for automating of SQL Databases and Applications deployment?

Author
Message
Dmitry Otblesk
Dmitry Otblesk
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 20
Are there any tools on the market for automating of SQL Databases and Applications deployment? I do not mean installation of SQL Server itself, I mean deployment of:

- SQL Database

- Populating database with initial data

- SSAS Databases

- SSIS packages

- SSRS reports

- Scheduling of SQL tasks

- Running various SQL scripts depending on user choices during install process

- Tie everything mentioned above together (so they use same databases, connections, user accounts, etc.)

I am looking for something similar to InstallShield (of this size and power) but more database oriented.

I know that some components mentioned above already have some deployment wizards available. But I am looking for one integrated solution, like one single executable file to run, which will do everything.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: Administrators
Points: 61817 Visits: 19099
Deployment Manager from Red Gate handles some of this. I know there are some open source tools, but I don't know of anything integrated. Since most of these are scriptable, I think lots of tools can run the deployment of users, logins, scheduling, if you have the scripts. Not sure about SSRS/SSAS/SSIS stuff.

http://www.red-gate.com/delivery/deployment-manager/

Disclosure: I work for Red Gate.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Dmitry Otblesk
Dmitry Otblesk
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 20
I already looked at RedGate Deploymnet manager. But so far I do not see that this product provides automation for deployment of SSAS, SSRS, SSIS. It looks like it is dealing with databases only.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: Administrators
Points: 61817 Visits: 19099
I'm not sure it does, but it packages things up, so there might be a hack. I'll ask.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Grant Fritchey
Grant Fritchey
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39289 Visits: 32618
Deployment Manager is focused currently on .NET code & databases.

I've never seen anything yet that can do SSIS, SSAS, and SSRS on top of everything else. I helped build a home-grown deployment tool at my last job and we didn't do SSAS or SSRS (SSIS, depending on how you run your SSIS packages, can be just copying the file, that one can be easy).

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Steve Jones
Steve Jones
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: Administrators
Points: 61817 Visits: 19099
I heard back that you can write powershell scripts to do this, which would make it repeatable, but require development on your part. I'll try to track down a sample I can post here.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search