Devam Ediyor

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.

Beceriler: .NET, Veri Tabanı Yönetimi, Microsoft SQL Server, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Livonia, United States

Proje NO: #19245258

Seçilen:

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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 555%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)
0.0

Bu iş için 18 freelancer ortalamada $601 teklif veriyor

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 Daha Fazla

$500 USD in 10 gün içinde
(11 Değerlendirme)
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 Daha Fazla

$1166 USD in 10 gün içinde
(9 Değerlendirme)
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 Daha Fazla

$700 USD in 15 gün içinde
(26 Değerlendirme)
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 Daha Fazla

$400 USD in 12 gün içinde
(5 Değerlendirme)
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 Daha Fazla

$800 USD in 10 gün içinde
(2 Değerlendirme)
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 Daha Fazla

$277 USD in 10 gün içinde
(16 Değerlendirme)
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 gün içinde
(14 Değerlendirme)
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 Daha Fazla

$750 USD in 30 gün içinde
(4 Değerlendirme)
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 Daha Fazla

$722 USD in 10 gün içinde
(2 Değerlendirme)
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 Daha Fazla

$555 USD in 10 gün içinde
(5 Değerlendirme)
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 Daha Fazla

$750 USD in 10 gün içinde
(1 Yorum)
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 Daha Fazla

$500 USD in 10 gün içinde
(3 Değerlendirme)
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 Daha Fazla

$666 USD in 20 gün içinde
(1 Yorum)
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 Daha Fazla

$300 USD in 10 gün içinde
(1 Yorum)
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 Daha Fazla

$500 USD in 3 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$616 USD in 7 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
0.0