ok, we've all been there. version 1 of your killer app is on the streets and selling like hotcakes. lots of happy clients have filled lots of tables with lots of data. one year on and you have finished version 2. naturally there are lots of new tables and lots of new fields in existing tables, some movement in the old table structure, relationships etc and of course lots of new stored procs as well as changes to existing ones. question is, what is the best way of managing this? backup all legacy data, re-install the complete new database and import or somehow tiptoe around what is already there, adding here, tweaking there. a friend who works for a large multi told me of a tool they spent 2 years developing to do exactly this and which now works seamlessly [so he says]. does anyone in the congregation know of a similar tool available that would do the job?
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
upgrading a sql server database
Collapse
X
-
-
interesting. i can't see it but do you know if it can compare an existing installation against a sql script? -
-
you may want to generate the scripts using SQLDiff and use a DTS to install any new lookup data alongside the create statements....
really you should have kept a change script as you worked on te system .. SQLDiff should only be used to check and verify the SQL scripts you have maintained while developing and testing..
How did you implement your test db?
Tut tut!!!--------------------------------------------------------------------------------
SA - Is it like a dragons nostril?Comment
-
I have used dbghost and it will do everything you are looking for:
http://www.innovartis.co.uk/DBGhost_home.asp
Working in many companies as an application support person, I go through pains of pinpointing problems when we upgrade or roll back releases...often finding that a Database SP or table had changed without knowledge.
The key is change control, but we all know that some things like tuning of indexes etc are often missed after a release. The worst thing ever is to find that a developer has spent months upon months developing against an incorrect baseline that is nothing like the environment in which his/her code is destined.
This product should help keep baselines in sync and get things right each time, its a new company, so perhaps they will come in a demo it for you...they did with my old client, a very nice KIWI bloke came in who actually founded the company.Comment
-
dbghost looks very cool. i'll def have a look at that. ta. i know kramer i know. things got slightly out of hand a few months back and the position was never recovered. hence the currrent need. tut for sure! but really, sql change management is a black art!Comment
-
Comment
-
Red-gates tools are king in this area.
If your needs are (as mine) a bit more complex then you can, by using the dev toolkit, build your own custom upgrade patch generator using .net, including using the data compare for extracting/modifying possible reference data.
it should be noted however that any tool (and there are others too, but my personal pref is red-gate), will only take you "so far", and you might have some issues, or more complex logic for handling of existing data etc, that you will need to look at manually.
- or just hire meComment
-
sql
can your users customise the system ? add bits ? write reports against your tables ?
how much is going to break when you roll out v2 ?
Do you only give them views or raw tables ?Comment
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Comment