I gang

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.

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

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Livonia, United States

Projekt ID: #19245258

Tildelt til:

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 Flere

$555 USD in 10 dage
(0 bedømmelser)
0.0

18 freelancere byder i gennemsnit $601 på dette 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 Flere

$500 USD in 10 dage
(11 bedømmelser)
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 Flere

$1166 USD in 10 dage
(9 bedømmelser)
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 Flere

$700 USD in 15 dage
(26 bedømmelser)
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 Flere

$400 USD in 12 dage
(5 bedømmelser)
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 Flere

$800 USD in 10 dage
(2 bedømmelser)
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 Flere

$277 USD in 10 dage
(16 bedømmelser)
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 dage
(14 bedømmelser)
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 Flere

$750 USD in 30 dage
(4 bedømmelser)
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 Flere

$722 USD in 10 dage
(2 bedømmelser)
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 Flere

$555 USD in 10 dage
(5 bedømmelser)
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 Flere

$750 USD in 10 dage
(1 bedømmelse)
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 Flere

$500 USD in 10 dage
(3 bedømmelser)
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 Flere

$666 USD in 20 dage
(1 bedømmelse)
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 Flere

$300 USD in 10 dage
(1 bedømmelse)
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 Flere

$500 USD in 3 dage
(0 bedømmelser)
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 Flere

$616 USD in 7 dage
(0 bedømmelser)
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 dage
(0 bedømmelser)
0.0