Make determination on approach to feed reporting database - SQL Server Broker or Integration Services

We process approximately 200,000-300,000 questions and answers a day from across the US in a learning database through an IIS based web interface on cloud servers. We'd like to move these records and their associated data to another cloud server and reporting database so we can take more time processing the data and create more reports and charts that would otherwise impact our production server and web interface. We intend to flatten (transform) the data so we can get a better feel for what the data indicates at any point in time. The questions are answered 24x7 but there are "light" times around midnight and on the weekends but still quite active.

We've looked at SQL Service Broker and triggers to move and transform the data as it changes as well as SQL Integration Services and SQL Data Tools to do the same. The output of this project should consider our system environment and describe the pros and cons of each approach. It should conclude with a high-level design of the recommended approach and a description of how it would work without needing to take into account the specifics of the database and its structure. Experience with Service Broker is the most important since it harder experience to find. Our longer term objective is to have the right person build the accepted design.

Taidot: .NET, Tietokannan hallinto, Microsoft SQL Server, SQL

Näytä lisää: converting access database sql server 2008, converting sql 2000 database sql server 2005 express, insert xml database sql server using vbnet, reporting services configuration manager cannot find server, change data capture sql server, the database you have selected is not a report server database, report server database tables, how to change service account for sql server reporting services, create report server database, ssrs and sql server database on different server, change data capture sql server 2016 standard edition, upload excel database sql server using, convert access database sql server 2008, convert access database sql server, converting access database sql server visual basic, convert database sql server 2000 2005, hotel project database sql server, set automatic backup database sql server 2005, days will convert access database sql server, convert access database sql server 2008 database

Tietoa työnantajasta:
( 0 arvostelua ) Livonia, United States

Projektin tunnus: #19245258

Myönnetty käyttäjälle:


I would just stick with the traditional approach of rolling up the data at some interval for reporting. If there is a slack time then that is normally the best time to do the rollup, assuming it is frequent enough to Lisää

$555 USD 10 päivässä
(0 Arvostelua)

18 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello, Dear How are you? I have read your project description and am ready for discussing with you about project. I have experienced in developing .NET, Database Administration, Microsoft SQL Server, SQL. I will wo Lisää

$500 USD 10 päivässä
(11 arvostelua)

PORTFOLIO [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] https://ma Lisää

$1166 USD 10 päivässä
(9 arvostelua)

Hi there. I got really excited with your project and I can say that really matches to my skills. Along as my worth experience of MS SQL programs, I can help and support you 100% bringing fully satisfactory result. I Lisää

$700 USD 15 päivässä
(26 arvostelua)

[login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] http://www.myfcpower.com. [login to view URL] http Lisää

$400 USD 12 päivässä
(5 arvostelua)

Hi, Greetings from Aravind Info Tech! We transform ideas into engaging digital experiences. Our Customized .Net Web Application Services. With several years of experience in .NET expertise, we deliver tailo Lisää

$800 USD 10 päivässä
(2 arvostelua)

Nice to meet you. I've read the project description and can develop definitely. I'll provide you with the highly skilled & professional HTML/CSS, PHP/WordPress/CodeIgniter, JavaScript, MySQL, front & back-end web dev Lisää

$277 USD 10 päivässä
(16 arvostelua)

Hi iam expertise onsql server and integration services please let me know indetail so that icould help u

$555 USD 10 päivässä
(14 arvostelua)

Hi, I am very interested to work on your project. I have 17+ years experience in Web Development using a large variety of programming languages, frameworks, database architecture, APIs, CRMs, ERPs, mobile develop Lisää

$750 USD 30 päivässä
(4 arvostelua)

Hi there, We've read the details of your project and its really interesting for us. We don't have experience with Service Broker but have the guys to do the R&D on it and start working. Looking forward to work with Lisää

$722 USD 10 päivässä
(2 arvostelua)

I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database - SQL Server, Oracle, MySQL BI - Microsoft MSBI and Inform Lisää

$555 USD 10 päivässä
(5 arvostelua)

Hello. I am really experienced Senior SQL Server Database Developer/Administrator/Business Intelligence Developer. I am currently working as such in London. I am really passionate about what I do and I extremely knowle Lisää

$750 USD 10 päivässä
(1 arvostelu)

hello,how are you. i read your bid carefully. i am C#, .Net, SQL Server expert and have full experience for 7 years. C#, .Net, SQL Server is my top skill and i can handle your project fully. I can provide most quali Lisää

$500 USD 10 päivässä
(3 arvostelua)

Respected Sir, Greetings of the Day ! I am Subham Das. I have 9+ years of competitive experience in web application development using .net and SQL server. I have 7+ years of experience in Database developme Lisää

$666 USD 20 päivässä
(1 arvostelu)

Hi. i am a full web developer with over 5 years on freelancer.com. ****In SPECIAL very familiar with .NET, ASP.NET, C#, MSSQL, MVC***** I have read your description and have interests in your project. I have ri Lisää

$300 USD 10 päivässä
(1 arvostelu)

Hi there, depending on frequency of data replication, I can give you detailed overview. For now it will be good to design DWH and SSIS packages to fill it. SSIS is right tool, because jou can transform data in proc Lisää

$500 USD 3 päivässä
(0 arvostelua)

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si Lisää

$616 USD 7 päivässä
(0 arvostelua)

I have experience to migrate data from server to server or premises using different ETL tools or programming language such as C#.

$500 USD 8 päivässä
(0 arvostelua)