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

Veja 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:
( 32 comentários ) Mississauga, Canada

ID do Projeto: #10497394

29 freelancers estão ofertando em média $192 para esse 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
(225 Comentários)
7.3
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
(179 Comentários)
6.8
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
(58 Comentários)
5.9
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
(4 Comentários)
5.1
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
(10 Comentários)
5.0
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
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
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
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
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
(4 Comentários)
3.2
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
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
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
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
Barcusiek

A proposal has not yet been provided

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

Good Day sir, I have been working with database development for around three years. I have worked on several project that included database modification according to business needs ( including new columns, making data Mais

$220 USD in 4 dias
(0 Comentários)
0.0