..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.
30 freelancers are bidding on average $189 for this job
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