Click here to Skip to main content
       

Database

 
AnswerRe: MS SQL - Tinyint - Default Value PinmemberMycroft Holmes16-Nov-12 15:11 
GeneralRe: MS SQL - Tinyint - Default Value Pinmemberjschell17-Nov-12 6:29 
GeneralRe: MS SQL - Tinyint - Default Value PinmemberMycroft Holmes17-Nov-12 15:06 
AnswerRe: MS SQL - Tinyint - Default Value PinmemberJammoD8716-Nov-12 22:30 
QuestionStaging Area PinmemberPhanindra26115-Nov-12 9:05 
AnswerRe: Staging Area Pinmembermark merrens15-Nov-12 9:37 
GeneralRe: Staging Area PinmemberPhanindra26116-Nov-12 0:14 
GeneralRe: Staging Area Pinmembermark merrens16-Nov-12 7:58 
No, I said the data was temporarily stored: the tables are a permanent fixture and are used to transition that data before it gets exposed in the production tables. For my purposes it's okay for the tables to reside in the prod database but that might not suit you. There is no reason it can't be a wholly separate database: that's up to you and the requirements.
 
All of the code is either in stored procedures and/or c#. The usual scenario is that the tables are truncated and (in my case) filtered data is dumped into them and then other processes may work on them and then the data is moved to the primary tables.
 
Note that this is just how our solution works for us: it may not be right for you. Use anything like this with extreme caution, especially near production data.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
 
me, me, me

QuestionRe: Staging Area PinmemberPhanindra26116-Nov-12 8:11 
AnswerRe: Staging Area Pinmembermark merrens16-Nov-12 8:34 
AnswerRe: Staging Area PinmemberMycroft Holmes16-Nov-12 15:20 
GeneralRe: Staging Area PinmemberS Douglas27-Nov-12 19:38 
GeneralRe: Staging Area PinmemberMycroft Holmes27-Nov-12 20:31 
GeneralRe: Staging Area PinmemberS Douglas29-Nov-12 7:52 
Questionfirst linq for entity frame work? PinmemberMember 875182715-Nov-12 1:02 
AnswerRe: first linq for entity frame work? Pinmemberdigimanus15-Nov-12 3:17 
QuestionBEGIN TRANSACTION AND COMMIT TRANSACTION Pinmembervanikanc14-Nov-12 7:40 
AnswerRe: BEGIN TRANSACTION AND COMMIT TRANSACTION PinmemberPhanindra26114-Nov-12 8:40 
QuestionFault Exception in WCF Services PinmemberPhanindra26114-Nov-12 6:15 
AnswerRe: Fault Exception in WCF Services PinmemberEddy Vluggen14-Nov-12 6:36 
GeneralRe: Fault Exception in WCF Services PinmemberPhanindra26114-Nov-12 8:05 
QuestionRelation multiple table using in C# PinmemberYBG13-Nov-12 2:53 
AnswerRe: Relation multiple table using in C# PinmemberPhanindra26114-Nov-12 8:23 
QuestionTrying to get a MySQL subquery to return multiple records PinmemberSQL Ed12-Nov-12 8:19 
AnswerRe: Trying to get a MySQL subquery to return multiple records PinmemberEddy Vluggen12-Nov-12 11:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.140821.2 | Last Updated 21 Aug 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid