Click here to Skip to main content
14,774,702 members
Home » Discussions » Database
   

Database

 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov20-Oct-20 10:29
MemberVictor Nijegorodov20-Oct-20 10:29 
QuestionDatabase design and custom query for this use case ? Pin
karengsh14-Oct-20 0:17
Memberkarengsh14-Oct-20 0:17 
QuestionShould I store files in a database? Pin
Member 1260015012-Oct-20 23:37
MemberMember 1260015012-Oct-20 23:37 
AnswerRe: Should I store files in a database? Pin
Richard Deeming12-Oct-20 23:54
mveRichard Deeming12-Oct-20 23:54 
QuestionMYSQL Pin
Member 147129666-Oct-20 11:21
MemberMember 147129666-Oct-20 11:21 
AnswerRe: MYSQL Pin
ZurdoDev6-Oct-20 11:34
professionalZurdoDev6-Oct-20 11:34 
QuestionDatabase scripts version control process/strategy? Pin
Member 1363071429-Sep-20 7:06
MemberMember 1363071429-Sep-20 7:06 
AnswerRe: Database scripts version control process/strategy? Pin
David Mujica29-Sep-20 8:48
MemberDavid Mujica29-Sep-20 8:48 
One way to approach this is to have a create a baseline set of scripts which created all of your DB objects: Tables, Indexes, Triggers, Stored Proc, etc. Check those scripts into a version control system () along with your source code. (Make a folder called "SQL" or something)

As you revise your application, create ALTER scripts for the DB objects (Tables, Indexes, Triggers, Stored Proc, etc) which will take the database from State A to State B.

Use some type of naming convention which will show the progress from one version to another.
"ALTER_tables_1.0.0_to_1.0.1"

When you get to a major release of the software, such as v2.0.0, then Re-Create the CREATE DB object scripts which will include all of your ALTER scripts; this way you don't have to keep rolling up schema changes.

ALSO: Take into consideration that you may need Data Manipulation scripts to "seed" some of your tables with basic data. Handle those scripts with something like ALTER_Data_1.0.0_to_1.0.1

Just giving you some ideas, not completely thought out, but I remember doing something like on previous projects.

BTW: I use Subversion / SVN / Tortoise as version control for myself.
AnswerRe: Database scripts version control process/strategy? Pin
ZurdoDev29-Sep-20 10:05
professionalZurdoDev29-Sep-20 10:05 
QuestionSimple Database design Pin
fdanos23-Sep-20 21:23
professionalfdanos23-Sep-20 21:23 
AnswerRe: Simple Database design Pin
Victor Nijegorodov23-Sep-20 21:54
MemberVictor Nijegorodov23-Sep-20 21:54 
AnswerRe: Simple Database design Pin
Mycroft Holmes24-Sep-20 13:18
professionalMycroft Holmes24-Sep-20 13:18 
QuestionWhy does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 3:35
professionalfd97507-Sep-20 3:35 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
Jörgen Andersson7-Sep-20 5:18
professionalJörgen Andersson7-Sep-20 5:18 
GeneralRe: Why does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 22:14
professionalfd97507-Sep-20 22:14 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
ZurdoDev21-Sep-20 8:03
professionalZurdoDev21-Sep-20 8:03 
QuestionHow to use a FileInfo control to add a filename to an Access database Pin
rodgerm25-Aug-20 15:51
Memberrodgerm25-Aug-20 15:51 
AnswerRe: How to use a FileInfo control to add a filename to an Access database Pin
Richard MacCutchan25-Aug-20 22:16
mveRichard MacCutchan25-Aug-20 22:16 
QuestionDATABASE KEY Pin
Member 1492238425-Aug-20 1:42
MemberMember 1492238425-Aug-20 1:42 
AnswerRe: DATABASE KEY Pin
OriginalGriff25-Aug-20 1:45
mveOriginalGriff25-Aug-20 1:45 
AnswerRe: DATABASE KEY Pin
ZurdoDev31-Aug-20 10:45
professionalZurdoDev31-Aug-20 10:45 
AnswerRe: DATABASE KEY Pin
Eddy Vluggen24-Sep-20 9:12
professionalEddy Vluggen24-Sep-20 9:12 
QuestionAny recommendations ora 01722 ??? Pin
Mahmoud Mohammad24-Aug-20 0:26
MemberMahmoud Mohammad24-Aug-20 0:26 
AnswerRe: Any recommendations ora 01722 ??? Pin
Richard Deeming24-Aug-20 1:42
mveRichard Deeming24-Aug-20 1:42 
Questionsql server express 2014 named instance not connecting from outside network Pin
Member 1258438314-Aug-20 2:28
MemberMember 1258438314-Aug-20 2:28 

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.