Encerrado

SQL Server Upgrade Script

..we have a Windows application that requires the customer to setup an database in any version of SQL Server.

Over the years we have added various fields to some of the tables. We need and SQL "UPGRADE" acript the customers of older versions can run to bring there database to the current schema Should work on all versions of SQL Server 2008 to present. The most recent schema can be found at:

[url removed, login to view]

we can provide the most current .MDF file for this schema if that is helpful.

Hi, there is not just an old and new schema we have about 6 differenet releases over the past 8 or 9 years. The data schemas from older versions will look similar to the current one, but usually missing a few fields from some of the tables. So the upgrade script would need to add the necessary fields from whatever database it is given.

Habilidades: Administração de Bancos de Dados, Microsoft SQL Server , Arquitetura de software, SQL

Ver mais: php xml data different server sql, freelancer server sql reporting services, synchronize sql server sql server, load pdf file sql server sql, radius server sql backend, online server sql crack, aspnet synchronize sql server sql express, save image sql server sql, sample windows mobile application server sql, tenfore client server sql server databse

Acerca do Empregador:
( 22 comentários ) Mississauga, Canada

ID do Projeto: #10497394

30 freelancers estão ofertando em média $189 para este trabalho

sumon355

Hello, I am very much interested to do this work as i have strong knowledge in sql server related works. i understand your requirements and i can create and provide you the required sql scripts. Looking forward to ha Mais

$150 USD in 3 dias
(199 Comentários)
7.1
customizedata

There are two ways to solve this problem. 1- If we already know which fields are added in which table then we can easily make a script and provide to customer. The scrip will be compatible with all the versions afte Mais

$170 USD in 3 dias
(172 Comentários)
6.6
weonlydo

Hi, This will require some complex coding to handle the defaults, foreign key and check constraints, preserve extended properties etc. Keeping identity columns (across child tables) also if you converted from regular Mais

$250 USD in 4 dias
(56 Comentários)
5.9
IMExpertEngineer

Hi, I've seen the table schema . Can you please share me your current script and tell me new fields that you want to be include in the script and I'll do it for you. I've over 10 years of experience in sql server Mais

$155 USD in 3 dias
(9 Comentários)
4.9
acronymsolutions

Hi , I am 16+ years experienced Database Programmer at CMMI-5 level company. We are working on : RDBMS :Oracle,MySQL,DB2, MSSQL Server 7.0/2000/2008R2 and Onwards. Database Tools : Database Configuration Assist Mais

$250 USD in 5 dias
(44 Comentários)
5.7
MarcoAGarcia

Hi, I’m software and database developer with more than 30 years experience. In the past 20 years I have worked (full-time, in-situ) for two international organizations (Inter-American Tropical Tuna Commission, in San D Mais

$833 USD in 15 dias
(2 Comentários)
4.8
yubor

hi, it would be good if you can provide all intermediate schemes that your customers have. cheers, yuri .

$222 USD in 10 dias
(36 Comentários)
4.5
dat2na

Hello, I'm professional DBA with 8+ years experience. Working as DBA and DB developer in one of the leader company. I have experience of same jobs like SQL Server Administration and development by remotely. I'm top exp Mais

$144 USD em 1 dia
(3 Comentários)
4.2
arunsankar555

Hi, I am an MCITP DBA with more than 10 years of experience in database technologies including MS SQL server. I can handle this requirement for you. Please message me when you're free so that we can discuss this in Mais

$98 USD in 2 dias
(11 Comentários)
3.9
handsum

Only Pay me If you 100% Satisfy with my work As per you requirement we have a team that will definitely provide best solution to you. We do fair code with reasonable price and client satisfaction is our Responsibil Mais

$150 USD in 5 dias
(4 Comentários)
3.3
YevgenyB

Hi I have an experience with MS SQL 13+ years (2000, 2008R2, 2014) so could help you. regards, Yevgeny

$111 USD in 3 dias
(3 Comentários)
3.4
XpaMoBHuk

hi, There is a way to automate the process, if you can provide an old and new SQL backups. So if this is possible, I can provide you a re-runnable upgrade SQL script in 1 day. Regards, Eugene

$100 USD em 1 dia
(3 Comentários)
3.6
andyborrero

hello im an expert developer with more than 20 years of experience. i mosly Work with GUI Windows applications with visual basic. i have experience making databases update script, all my applications have an SQL update Mais

$150 USD in 3 dias
(5 Comentários)
3.2
mozammalidbctg

Hi, I am experts in .Net ,ASP.NET Web Development, Responsive design - HTML5, CSS3, jQuery, AJAX,JavaScript,MSSql server 2005,2008 ,2012,2014,MySql,C#,Crystal report. 100% responsive web design with bootstap css Mais

$155 USD in 3 dias
(3 Comentários)
3.2
hemamalinib

Hello I am Hema, having 10 years experience in software development. Worked on various database projects on Oracle , MS SQL Server, MYSQL and POSTGRESQL. I am passionate working on database programming especially Oracl Mais

$170 USD in 7 dias
(2 Comentários)
3.0
kotiwel

I can help you with this.

$225 USD in 10 dias
(1 Comentário)
1.6
abokhdeer2002

A proposal has not yet been provided

$133 USD in 3 dias
(0 Comentários)
0.0
buschka

Hello. With a current backup of the database and a listing of the fields necessary to possibly upgrade to, I can have a script or stored procedure for you to run that will upgrade all tables in a customer's database to Mais

$138 USD in 5 dias
(0 Comentários)
0.0
lplachky

I have a 5+ years experience in T-SQL development (ETL scripts, CLR, stored procedures, cursors, dynamic scripts, transactions and so on). As BI/SQL developer I did upgrade scripts aproximately every each 3 months, dep Mais

$155 USD in 10 dias
(0 Comentários)
0.0
Barcusiek

A proposal has not yet been provided

$250 USD in 10 dias
(0 Comentários)
0.0