Click here to Skip to main content
14,983,791 members
Home / Discussions / Database
   

Database

 
QuestionChange old store to new store Pin
Member 1333807514-Nov-17 18:13
MemberMember 1333807514-Nov-17 18:13 
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 
I'm getting ready to start a new C#/WPF project for a client. The database will be SQL Server. Myself and another developer will both work remotly.

So there's two development PC's, each with SQL on them. Then my server will be used to test, so there's a copy of the DB there. Then there's the production DB on the client's server.

I expect that I'll be creating, editing, and deleting DB objects continuously. I will probably use scripts for these changes so I can then run the scripts on either the test or production servers. Also, other developers will need to run them.

The question is about how to manage the changes/scripts. What process do you follow for this? Is there a naming convention? How do you keep everything in sync?

Thanks
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

AnswerRe: Managing Database Changes Pin
David Mujica8-Nov-17 5:53
MemberDavid Mujica8-Nov-17 5:53 
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 

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.