Click here to Skip to main content
15,923,142 members
Home / Discussions / Database
   

Database

 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 22:01
Martin Niemandt20-Feb-14 22:01 
GeneralRe: intricate date query sql Pin
Jörgen Andersson20-Feb-14 21:28
professionalJörgen Andersson20-Feb-14 21:28 
GeneralRe: intricate date query sql Pin
Martin Niemandt20-Feb-14 22:04
Martin Niemandt20-Feb-14 22:04 
QuestionMSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
Prasad A19-Feb-14 19:26
Prasad A19-Feb-14 19:26 
AnswerRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
GuyThiebaut19-Feb-14 21:46
professionalGuyThiebaut19-Feb-14 21:46 
GeneralRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
Prasad A19-Feb-14 22:08
Prasad A19-Feb-14 22:08 
GeneralRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
GuyThiebaut19-Feb-14 22:24
professionalGuyThiebaut19-Feb-14 22:24 
QuestionUpdate Database for C# application Pin
PDTUM19-Feb-14 6:06
PDTUM19-Feb-14 6:06 
So...it seemed like a good idea at the time. I have a C# application that is distributed among multiple users (about a dozen). I set each user up with their own database (MS SQL 2005) so there is no interaction between users and it works great. Now, I am making a change to the program which requires a change to the database. In the past, with just a few users, I simply went into each database and altered the tables one at a time ... takes a few minutes for each one. But as the number of users grow and I keep adding features to the application more frequently ... well, you can see where this is going. My question is; what type of command can I use to alter the databases (a script of some kind?) to add or remove columns from tables, add tables, etc. to make it so that I can alter multiple identical database structures at the same time while maintaining the data in them. Although I have been making databases for my applications for about 15 years, this is an area that I have never had to deal with; something I would assume would normally be the job of a dedicated DBA. If applications end up being sold on a larger scale (and it is heading that way), then I would hire such a person immediately. I considered having everyone in a single large database at the start and simply use proper queries to pull the data, but I decided that the sheer size and loss of performance would not make it as nice as it is, especially if I were to end up with several hundred users. There are about 30 tables in the database. I never really understood the limits and capabilities of these databases; only to say I don't really trust them to do the job when they get too large(not very scientific; more of a gut feeling). Am I way underestimating the ability of the database? Until then, can you give me a lead in on how to do this? I love it here at Code Project and I Thank You for your time....Pat
AnswerRe: Update Database for C# application Pin
David Mujica19-Feb-14 8:39
David Mujica19-Feb-14 8:39 
AnswerRe: Update Database for C# application Pin
PDTUM20-Feb-14 5:54
PDTUM20-Feb-14 5:54 
QuestionRe: Update Database for C# application Pin
Nicholas Swandel21-Feb-14 3:55
Nicholas Swandel21-Feb-14 3:55 
AnswerRe: Update Database for C# application Pin
PDTUM21-Feb-14 5:50
PDTUM21-Feb-14 5:50 
GeneralRe: Update Database for C# application Pin
Nicholas Swandel21-Feb-14 6:20
Nicholas Swandel21-Feb-14 6:20 
Questionbegin tran in sql server 2008 Pin
vkEE19-Feb-14 5:22
vkEE19-Feb-14 5:22 
AnswerRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 6:02
professionalGuyThiebaut19-Feb-14 6:02 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 6:13
vkEE19-Feb-14 6:13 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 6:27
professionalGuyThiebaut19-Feb-14 6:27 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 6:43
vkEE19-Feb-14 6:43 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 7:32
professionalGuyThiebaut19-Feb-14 7:32 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 8:25
vkEE19-Feb-14 8:25 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 8:43
professionalGuyThiebaut19-Feb-14 8:43 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 8:52
professionalEddy Vluggen19-Feb-14 8:52 
GeneralRe: begin tran in sql server 2008 Pin
Ananth A21-Feb-14 0:43
Ananth A21-Feb-14 0:43 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut21-Feb-14 0:56
professionalGuyThiebaut21-Feb-14 0:56 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 8:25
professionalEddy Vluggen19-Feb-14 8:25 

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.