Sedang Disiapkan

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.

Kemahiran: .NET, Pentadbiran Pangkalan Data, Pelayan Microsoft SQL, SQL

Lihat lagi: 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

Tentang Majikan:
( 0 ulasan ) Livonia, United States

ID Projek: #19245258

Dianugerahkan kepada:

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 Lagi

$555 USD dalam 10 hari
(0 Ulasan)
0.0

18 pekerja bebas membida secara purata $601 untuk pekerjaan ini

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 Lagi

$500 USD dalam 10 hari
(11 Ulasan)
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 Lagi

$1166 USD dalam 10 hari
(9 Ulasan)
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 Lagi

$700 USD dalam 15 hari
(26 Ulasan)
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 Lagi

$400 USD dalam 12 hari
(5 Ulasan)
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 Lagi

$800 USD dalam 10 hari
(2 Ulasan)
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 Lagi

$277 USD dalam 10 hari
(16 Ulasan)
4.4
sreenivas2903

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

$555 USD dalam 10 hari
(14 Ulasan)
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 Lagi

$750 USD dalam 30 hari
(4 Ulasan)
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 Lagi

$722 USD dalam 10 hari
(2 Ulasan)
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 Lagi

$555 USD dalam 10 hari
(5 Ulasan)
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 Lagi

$750 USD dalam 10 hari
(1 Ulasan)
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 Lagi

$500 USD dalam 10 hari
(3 Ulasan)
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 Lagi

$666 USD dalam 20 hari
(1 Ulasan)
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 Lagi

$300 USD dalam 10 hari
(1 Ulasan)
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 Lagi

$500 USD dalam 3 hari
(0 Ulasan)
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 Lagi

$616 USD dalam 7 hari
(0 Ulasan)
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 dalam 8 hari
(0 Ulasan)
0.0