Click here to Skip to main content
15,878,231 members
Home / Discussions / Database
   

Database

 
GeneralRe: problem modeling messages tables Pin
ahmadiss22-Jul-12 5:12
ahmadiss22-Jul-12 5:12 
Questionhow to stop sql server 2005 Pin
sumeet kumar Attri18-Jul-12 21:38
sumeet kumar Attri18-Jul-12 21:38 
AnswerRe: how to stop sql server 2005 Pin
Karthik Harve18-Jul-12 22:26
professionalKarthik Harve18-Jul-12 22:26 
GeneralMaking a row-based Iteration of a Bulk-Insertion Pin
SkyRunner18-Jul-12 21:16
SkyRunner18-Jul-12 21:16 
AnswerRe: Making a row-based Iteration of a Bulk-Insertion Pin
Eddy Vluggen18-Jul-12 23:34
professionalEddy Vluggen18-Jul-12 23:34 
GeneralRe: Making a row-based Iteration of a Bulk-Insertion Pin
Michael Potter19-Jul-12 3:50
Michael Potter19-Jul-12 3:50 
GeneralRe: Making a row-based Iteration of a Bulk-Insertion Pin
SkyRunner19-Jul-12 5:08
SkyRunner19-Jul-12 5:08 
QuestionSSIS and SSAS Pin
Member 927049917-Jul-12 21:06
Member 927049917-Jul-12 21:06 
Hi
I have a requirement to migrate the data from my standard OLTP database into an OLAP database based on the firing of a particular event. There will be some calculations performed on the OLTP data and the calculated/aggregated data will be inserted into the OLAP database.

I have 2 options to do this.
1. Use a web service to insert data into the OLTP database, make required calculations and then insert the data into the OLAP database from within the web service itself.
2. Use SSIS to migrate the data from the OLTP database into the OLAP database.

I am confused as to which option is better in terms of performance, security, maintainability as well as scalability of the application. My application deals with huge amounts of data which is required to be used for generation of reports.

Thanks
AnswerRe: SSIS and SSAS Pin
Mycroft Holmes18-Jul-12 13:00
professionalMycroft Holmes18-Jul-12 13:00 
QuestionRe: SSIS and SSAS Pin
Jan Steyn19-Jul-12 3:59
Jan Steyn19-Jul-12 3:59 
QuestionMicrosoft reporting services Pin
berba17-Jul-12 0:44
berba17-Jul-12 0:44 
QuestionDeleting Data Using Job Scheduler Pin
ASPnoob16-Jul-12 22:59
ASPnoob16-Jul-12 22:59 
AnswerRe: Deleting Data Using Job Scheduler Pin
rimazuc17-Jul-12 0:00
rimazuc17-Jul-12 0:00 
AnswerRe: Deleting Data Using Job Scheduler Pin
Michael Potter17-Jul-12 3:38
Michael Potter17-Jul-12 3:38 
QuestionAn Iteration with renaming and avoiding duplicates Pin
SkyRunner16-Jul-12 8:37
SkyRunner16-Jul-12 8:37 
QuestionRe: An Iteration with renaming and avoiding duplicates Pin
Suvabrata Roy16-Jul-12 8:55
professionalSuvabrata Roy16-Jul-12 8:55 
AnswerRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 2:36
SkyRunner17-Jul-12 2:36 
AnswerRe: An Iteration with renaming and avoiding duplicates Pin
Mycroft Holmes16-Jul-12 12:58
professionalMycroft Holmes16-Jul-12 12:58 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 2:39
SkyRunner17-Jul-12 2:39 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
Mycroft Holmes17-Jul-12 2:59
professionalMycroft Holmes17-Jul-12 2:59 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 3:08
SkyRunner17-Jul-12 3:08 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 3:44
SkyRunner17-Jul-12 3:44 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
Michael Potter17-Jul-12 3:52
Michael Potter17-Jul-12 3:52 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 4:11
SkyRunner17-Jul-12 4:11 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
Michael Potter17-Jul-12 4:51
Michael Potter17-Jul-12 4:51 

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

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