Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2010-03-01 : 03:48:56
|
| we have BI server.today i asked to know how to work with development and production servers.i mean how to migrate changes made in the development environment to production environment? (how do you wotk eith dev and pro enviroment?)dev enviroment ia alway same like production enviroment? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-01 : 11:10:13
|
| what all changes you want to migrate? SSRS,SSIS or SSAS?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2010-03-01 : 11:27:30
|
| In case of SSIS, you need to maintain same folder structure as PROD in DEV. Please note that, in DEV environment all developers have full access to Import / export the SSI packages and config files. where as PROD should NOT have any access to MSDB\Packages or config file(s).Some times, you need to maintain SQL login accounts to run the packages in dev connecting to cross plotforms. Please make sure that, PROD passwords (SQL and service account) should not give it to developers.With RegardsSR |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-03-01 : 13:19:02
|
| i need to migrate the change in ssis and in all the database (staging,United_DWH,etc),is the dev need to be update all the time? |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2010-03-02 : 07:00:39
|
quote:
Originally posted by inbs
we have BI server.today i asked to know how to work with development and production servers.i mean how to migrate changes made in the development environment to production environment? (how do you wotk eith dev and pro enviroment?)dev enviroment ia alway same like production enviroment?
you should better register for a sql server training or should look for free training available on internet... |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-03-02 : 15:26:09
|
| do you have link to any article about it? |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2010-03-03 : 06:25:40
|
quote:
Originally posted by inbs
do you have link to any article about it?
there are lot of articles, just go through technet,msdn,sqlservercentral etc...go through articles, try it yourself..u will not learn unless u try it.... |
|
|
|
|
|
|
|
|
development and production