SQL2005 to 2014 migration

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

Hello, As an expert in ms sql server, i am very much interested to do this work. Please let me know the detail. Thanks

Hi, I'd be happy to work with you to upgrade your 2005 version databases and jobs to SQL Server 2014. It would be useful to provide an accurate bid if you could get back to me with more detail on number of databases and jobs and database sizes. Look forward to hearing from you. Damian

Professional Experience - Highlights • 8+ years of experience in MS SQL Server development • 6+ years of experience in C# asp.net application development • 2+ years of experience in vb 6.0 Application development • 4+ years of experience in SSIS development • Health Care, Financial, Renewable Energy and E-Commerce domain • 3 projects experience webscraping • Worked on web applications and windows applications using C#, asp.net, MS SQL server and SSIS technologies. • Developed more than 10 web applications, more than 3 windows applications using c#, asp.net and MS SQL server in Financial, Renewable Energy and E-Commerce domain. • Expert in developing complex store procedures, SQL scripts, efficient triggers, required functions, creating indexes and indexed views for performance. Experience in writing complex SQL queries involving multiple tables inner and outer joins • Experience in monitoring SQL Server Performance tuning, identifying dead locks and resolving them in SQL Server 2008 using SQL Profiler • Expert in designing ETL data flows using SSIS; Worked extensively on ETL process using SSIS package from Excel, Flat Files to SQL Server databases • Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging

I am sql server dba having more then 10 yrs of experience and I have done migration from 2005 to 2014 with ssis packages. I can do this task in 2 days

Hi Dear I have a lot of experience in DataBases ,Data Warehous,DB2 , Teradata etc . I am DataBases + Warehouse certified from Oracle,postgresSQL,SQL SERVER , Access. I have done many work in Requirements analysis , Data Staging, Data Warehouse, DataBases. I am expert in developing ERD, Front-End, Backend, Security, Optimization, SSIS, SSRS. I have strong command on queries too.I see your work & too much interesting in your work. My rates is also too much low. I assure you I am the best for your work. Kindly reply me so that we negotiate on price & then start working on it Have a good day Thank you

I have more then 3 years of an experience in database migration and SQL server administration. You can message me here for fore information.

I am Krunal K. Doshi from INDIA having 12+ year of experience in IT field having completed majority of projects with Microsoft Technologies. I have a team of experience programmers expertise in .NET(MVC and traditional Web Forms), Android, iOS etc.. I understand you would like to move your existing SQL DB from SQL 2005 to SQL 2014 which can be easily done with backup however tricky part is setting up the jobs and making it run properly; I'm confident if given an opportunity we can do a great job for you. I have placed my bid just to get in contact with you and establish long term relationship with you. Looking forward to an opportunity to discuss this project with you and work on it.

Greetings, I'm professional database expert with 8+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs like database administration and development by remotely. I'm top expert. -- Best regards, Davit Dartsimelia Senior Database Administrator & Developer

Hi! I'm a SQL Server expert with 10+ years of experience, I can help you to export users, databases, jobs to your new server. Thanks in advance!

Hello

I have more that 10 years experience with MS SQL Server 2000/2005/2008/2012 and MS BI (SSAS, SSIS and SSRS). I have worked like DBA, SQL Developer and BI Developer. I have migrated and develop some process to sync between MySQL, Oracle, Informix and Flat Files.

Expert here, i can do your work easily.............................................................................................................

Db administrator

No of days depends on size of database and no of databases need to be migrate.

Dear Sir/Madam, The nature of my degree course has prepared me for this position. It involved a great deal of independent research, requiring initiative, self-motivation and a wide range of skills. For one course, [SQL server], an understanding of the [IT] industry was essential. I found this subject very stimulating. I am a fast and accurate writer, with a keen eye for detail and I should be very grateful for the opportunity to progress to given profile. I am able to take on the responsibility of this position immediately, and have the enthusiasm and determination to ensure that I make a success of it. Thank you for taking the time to consider this application and I look forward to hearing from you in the near future. Yours sincerely Rakesh Rao MG

Hi there, What do you expect to be done? I can deploy a new SQL 2014 instance in a new server and migrate there databases there.

I have done migration for SQL 2005 to 2012 before.I have also experience in migrating SSIS packages too.

I am Microsoft Data Platform MVP working in complex database systems day in and day out. I have best avaipability of resources for migrations as I have recently worked on upgrade projects to 2014 and 2016. I am confident that I will be the best resource for your job.

I have worked on multiple successful migration projects ranging from SQL server 2005 to 2014 migrations including multiple servers and databases with very high complexity

A proposal has not yet been provided