Click here to Skip to main content
14,602,794 members
   

Database

 
AnswerRe: Change old store to new store Pin
Richard Deeming15-Nov-17 2:47
mveRichard Deeming15-Nov-17 2:47 
AnswerRe: Change old store to new store Pin
CHill6015-Nov-17 10:23
mveCHill6015-Nov-17 10:23 
QuestionSSIS throwing error as: Did not read byte array properly Pin
indian1438-Nov-17 8:14
Memberindian1438-Nov-17 8:14 
AnswerRe: SSIS throwing error as: Did not read byte array properly Pin
CHill6011-Nov-17 3:38
mveCHill6011-Nov-17 3:38 
GeneralRe: SSIS throwing error as: Did not read byte array properly Pin
indian14312-Nov-17 20:24
Memberindian14312-Nov-17 20:24 
AnswerRe: SSIS throwing error as: Did not read byte array properly Pin
jschell15-Nov-17 7:52
Memberjschell15-Nov-17 7:52 
QuestionManaging Database Changes Pin
Kevin Marois8-Nov-17 5:04
professionalKevin Marois8-Nov-17 5:04 
AnswerRe: Managing Database Changes Pin
David Mujica8-Nov-17 5:53
MemberDavid Mujica8-Nov-17 5:53 
In a previous position, we used the following DB script pattern:

1) For each major release, have a set of "Create" scripts.
a) Create Table_1.0.0, Create_Index_1.0.0, Create_Sysdata_1.0.0 (or something like that)
2) Each time there is an upgrade, create a set of scripts
a) Upgrade_Table_1.0.0_1.0.01, Upgrade_index_1.0.0_1.0.1 (and so on)

Make sure you are using a source code control system where you would be checking in not only your source code, but your SQL scripts.

When you have a "build" you will also pickup the correct version of database scripts.

Also, you should have a Build / Deploy box where you can Create or Upgrade databases anytime for QA testing. It is always a good test to be able to take a backup of your client's database and run the upgrade scripts to prove them out.

The only version control system I've used is Subversion. If you are not familiar with them, check them out and setup a proper team development environment, you will save yourself lots of headaches.

Just my 2 cents.
David
AnswerRe: Managing Database Changes Pin
jschell8-Nov-17 7:33
Memberjschell8-Nov-17 7:33 
AnswerRe: Managing Database Changes Pin
Mycroft Holmes8-Nov-17 14:10
professionalMycroft Holmes8-Nov-17 14:10 
AnswerRe: Managing Database Changes Pin
kmoorevs11-Nov-17 9:58
Memberkmoorevs11-Nov-17 9:58 
GeneralRe: Managing Database Changes Pin
Richard Deeming13-Nov-17 1:49
mveRichard Deeming13-Nov-17 1:49 
GeneralRe: Managing Database Changes Pin
kmoorevs13-Nov-17 8:29
Memberkmoorevs13-Nov-17 8:29 
QuestionGet specific records from DB Pin
_Flaviu28-Oct-17 23:08
Member_Flaviu28-Oct-17 23:08 
AnswerRe: Get specific records from DB Pin
A_Griffin28-Oct-17 23:48
MemberA_Griffin28-Oct-17 23:48 
AnswerRe: Get specific records from DB Pin
Mycroft Holmes28-Oct-17 23:54
professionalMycroft Holmes28-Oct-17 23:54 
QuestionA question about the behavior of Jet and Ace drivers Pin
indian14324-Oct-17 7:58
Memberindian14324-Oct-17 7:58 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
PIEBALDconsult24-Oct-17 8:32
professionalPIEBALDconsult24-Oct-17 8:32 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
indian14325-Oct-17 7:15
Memberindian14325-Oct-17 7:15 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
jschell27-Oct-17 7:43
Memberjschell27-Oct-17 7:43 
QuestionMath expression as Column value as string in the Dynamic Sql Pin
indian14319-Oct-17 7:19
Memberindian14319-Oct-17 7:19 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
Richard MacCutchan19-Oct-17 7:33
mveRichard MacCutchan19-Oct-17 7:33 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
indian14319-Oct-17 8:10
Memberindian14319-Oct-17 8:10 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
jschell20-Oct-17 9:27
Memberjschell20-Oct-17 9:27 
GeneralRe: Math expression as Column value as string in the Dynamic Sql Pin
Eddy Vluggen20-Oct-17 10:47
professionalEddy Vluggen20-Oct-17 10:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.