Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Are there tools for automating of SQL Databases and Applications deployment? Expand / Collapse
Author
Message
Posted Monday, February 04, 2013 4:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 13, 2014 9:26 PM
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.
Post #1415529
Posted Monday, February 04, 2013 5:21 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:29 PM
Points: 32,819, Visits: 14,965
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
Post #1415536
Posted Monday, February 04, 2013 5:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 13, 2014 9:26 PM
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.
Post #1415541
Posted Monday, February 04, 2013 6:35 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:29 PM
Points: 32,819, Visits: 14,965
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
Post #1415548
Posted Tuesday, February 05, 2013 3:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:25 PM
Points: 14,835, Visits: 27,311
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1415694
Posted Tuesday, February 05, 2013 8:43 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:29 PM
Points: 32,819, Visits: 14,965
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
Post #1415902
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse