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 |
|
osupratt
Posting Yak Master
238 Posts |
 Posted - 2008-12-16 : 13:07:20
|
| I am an analyst that has no true hands on to servers, etc. I have an IT group that currently replicates an accounting application for me to run reports against, etc. We have another application that they want to replicate in the same fashion, but are telling me that any Views or Stored Procedures that I send to them to place on the server against this application will be lost nightly.Does anyone have any experience with this phenomenon; and if so, is there a way of doing this that will keep my script loaded? Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
osupratt
Posting Yak Master
238 Posts |
Posted - 2008-12-16 : 20:55:51
|
| Thanks for the response. Just curious why they don't have to do any of this on the currently application that they replicate? I have plenty of script on this database? Also, when you say 'source' database what do you mean? Thanks. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-12-16 : 22:05:28
|
| By source database, I am referring to the accounting system you referenced. That is the source of your data. That data gets replicated to your report database. When I mentioned scripts, I meant that you could provide your code (views, stored procedures, ...) to the DBA that setup the replication process so that your code would be made available each time the report database was refreshed.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
replication removes Views and Stored Procs?