the location of stored procedures.

Question

the location of stored procedures.

Viewing 6 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

I'd put them in the staging database, just to keep it self-contained. Easier to document that way.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

azdzn SSCarpal Tunnel Points: 4128 More actions · Answer 2

Do you have backup of your staging database ?

Do you have a repository with all your staging database script ?

If both answers are no, I'll put that into production database.

Otherwise, staging database.

GSquared SSC Guru Points: 260824 More actions · Answer 3

azdzn (1/13/2012)
Do you have backup of your staging database ?
Do you have a repository with all your staging database script ?
If both answers are no, I'll put that into production database.
Otherwise, staging database.

I'm so used to using source control that not having the procedures saved somewhere didn't occur to me as a possibility.

Definitely make sure they're saved, along with anything else from the staging database (table definitions, any static lookup table content that's not part of the load data, etc.).

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

azdzn SSCarpal Tunnel Points: 4128 More actions · Answer 4

I'm so used to using source control that not having the procedures saved somewhere didn't occur to me as a possibility.

Just in case 🙂

andersg98 SSCertifiable Points: 5180 More actions · Answer 5

isn't it more efficient to process the load all in the SSIS pipeline?

if you are just calling stored procedures from the SSIS package then you might as well just skip SSIS and run the procedures from a SQL agent job. or am I missing something?

sqlfriend SSC Guru Points: 52794 More actions · Answer 6

andersg98 (1/13/2012)
isn't it more efficient to process the load all in the SSIS pipeline?
if you are just calling stored procedures from the SSIS package then you might as well just skip SSIS and run the procedures from a SQL agent job. or am I missing something?

The packages have other tasks other than SQL tasks, and it has parent pacakges, and 30 child packages. So calling from SQL agent job just for that stored procedure is not what I want.

Thanks