In Progress

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.

Skills: .NET, Database Administration, Microsoft SQL Server, SQL

See more: 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

About the Employer:
( 0 reviews ) Livonia, United States

Project ID: #19245258

Awarded to:

vw1415275vw

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 More

$555 USD in 10 days
(0 Reviews)
0.0

18 freelancers are bidding on average $601 for this job

mingxiao2008

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 More

$500 USD in 10 days
(11 Reviews)
6.2
fullymagento

PORTFOLIO [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] https://ma More

$1166 USD in 10 days
(9 Reviews)
5.8
limillion819

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 More

$700 USD in 15 days
(26 Reviews)
5.7
abstractsoftweb

[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 More

$400 USD in 12 days
(5 Reviews)
5.4
aitindia

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 More

$800 USD in 10 days
(2 Reviews)
4.1
kipdev13

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 More

$277 USD in 10 days
(16 Reviews)
4.4
sreenivas2903

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

$555 USD in 10 days
(14 Reviews)
4.2
adicoman

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 More

$750 USD in 30 days
(4 Reviews)
3.8
ludiac

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 More

$722 USD in 10 days
(2 Reviews)
4.5
jayantavkumar

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 More

$555 USD in 10 days
(5 Reviews)
3.1
yavorvrachev

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 More

$750 USD in 10 days
(1 Review)
2.7
goldsea808

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 More

$500 USD in 10 days
(3 Reviews)
3.1
udalcorpo

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 More

$666 USD in 20 days
(1 Review)
1.9
ludwig333

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 More

$300 USD in 10 days
(1 Review)
0.8
dubravkom

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 More

$500 USD in 3 days
(0 Reviews)
0.0
xavient3

"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 More

$616 USD in 7 days
(0 Reviews)
0.0
salmanahmad90

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

$500 USD in 8 days
(0 Reviews)
0.0