|
Hi!
I have a small C# program that runs in multiple instances over a LAN and uses a database running on a seperate server. Now I need to make changes to the database layout by adding a few tables and extending an existing table with a few more columns.
How do I do this the right way? Can anybody point me in the direction of a tutroial or such information to get me started?
If it helps : The database is "Microsoft SQL Database 2008" and C# is the 2008 flavour.
Sure, I can make a new database and then export/import the from the old database, but I would much rather use a update through an installation-package so that the person updating don't have to be a certified tech. This change need's to be done on several locations and some of the users are just that - users 
Thanks in advance!
|
|
|
|
|
I'd write a script and ask them to run it.
|
|
|
|
|
Will the applications be running when you do the update?
When you say "several locations" you mean that there are the database itself exists in several locations?
Probably the absolute easiest way from the users stand point would be the following
1. Create a C# program that does nothing by applies the changes. Do NOT put this in the main app.
2. Create an installer which runs that app. It might also update the real app, see below.
Also as a suggestion the following might be useful.
1. Create a table which the sole purpose is to keep track of the database schema version. Thus for this release you would insert into that table something like 'MyApp', '2.0', <current date="">
2. Have your application verify the version on start up and refuse to run (error message) if the version does not match.
If you do this your C# database update program can verify the database version before applying the update. Note as well that you do not need to embed the update SQL in the database update application. It can read it from an included SQL file.
|
|
|
|
|
Thanks! That sounds like what I need 
Small clarification for posterity:
Each LAN installation has one databas and several C#-clients. THis installation is then done on several LANs.
|
|
|
|
|
Let's say I have a store procedure returning Value, Desired_Row_Header, and Desired_Column_Header.
EXEC [dbo].[scsp_My_Query]
Can I pivot the results of the stored procedure directly or do I have to embed the pivot in the stored procedure?
I am currently fetching the results off the database and manually creating pivot tables in code. I'd like to move it on the database, especially if I can do the pivot based on the column position without having to lookup the names of each column.
|
|
|
|
|
Have you tried
CREATE TABLE #tmp(Value varchar(20), Desired_Row_Header varchar(20), Desired_Column_Header varchar(20))
INSERT INTO #tmp
exec scsp_My_Query
Now do your pivot on #tmp
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
No, I hadn't tried doing that. It sounds like a good idea and I will try it out.
I have gotten some pivots to work with arbitrary # of columns, but I've had to use dynamic sql.
|
|
|
|
|
T2102 wrote: I have gotten some pivots to work with arbitrary # of columns, but I've had to use dynamic sql.
Yea if the columns before execution time are not known then you will need to resort to dynamic SQL.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
Beware if you are creating executables on a Win7.1 system that use the ADODB libraries. Your executable will not work on other systems. (except for other Win7 SP1) http://support.microsoft.com/kb/2517589
"Go forth into the source" - Neal Morse
|
|
|
|
|
How to call function from a Stored Procedure
|
|
|
|
|
I got one solution : Here it is,-
SELECT *
FROM table1
WHERE attribute1 IN (SELECT * FROM dbo.fn1('ab'))
modified on Friday, April 15, 2011 10:13 PM
|
|
|
|
|
prasanta_prince wrote: I got one solution
Glad you got one yourself.
prasanta_prince wrote: Here it is,-
SELECT *
FROM table1
WHERE attribute1 IN (SELECT * FROM dbo.fn1('ab'))
BTW please put the code in code block always like below.
SELECT *
FROM table1
WHERE attribute1 IN (SELECT * FROM dbo.fn1('ab'))
Cheers.
|
|
|
|
|
Thanks , i will do it from next time..
|
|
|
|
|
SET @my_variable =SELECT dbo.my_function(@my_function_parameter)
|
|
|
|
|
Hi,
I am creating a Schema Bound View on Database 'B', which contains select statement from Database 'A'. I searched and i found that i schema bound view must refer same database objects only.
My original aim was to create Index on view, to boost performance. Is there any other way to boost performance or create index on views? View is center of access and is already being in use in most projects, so i have to do everything with this view only.
Note: I only have select access to Database 'A' and no DDL operations.
Thanks.
♫ 99 little bugs in the code,
99 bugs in the code
We fix a bug, compile it again
101 little bugs in the code ♫
|
|
|
|
|
hi..
i'm facing a new problem in ssrs reports ...
i have hosted an asp.net application which is running fine in XP..
but when i open the application in UBANTU OS application is working
fine but reports in kannada are not displaying
it is displaying some russian character .. same problem when i
export to PDF it is displaying some russian character..
In windows XP prof3 Kannada reprots are working fine..
but in ubantu OS it is not displaying the fonts..
what to do... ? help me....
|
|
|
|
|
1) Try to use Unicode instead of a special Windows code page.
2) Indian fonts are not very common, I wouldn't expect to find any Indian fonts except perhaps Devanagari on a "normal" computer. You have to install the fonts. In Ubuntu (I guess you mean Ubuntu when you say Ubantu), some South Indian localizations are available for the system, I don't know for Kannada. Just install some of these localizations, and the respective fonts will also be installed. Then test with Firefox and a web page in that language.
Oh, let's try:
ಕರ್ನಾಟಕ
|
|
|
|
|
how can i creat a report for databse i have in c# ?
|
|
|
|
|
Assuming you are using Visual Studio ... you would add a Crystal Report to your project.
Do a search on Crystal Reports here in CodeProject and you will find all kinds of articles on how to use it.
|
|
|
|
|
|
|
Yes it is. And since it's native for Sql Server, I'd say you have lot's of opportunities when you play with it
|
|
|
|
|
codeproject is may interested site and is my project for software engineering 2 in university
.please send me the er of codeproject.com
|
|
|
|
|
r.kh wrote: please send me the er of codeproject.com
er?
|
|
|
|
|
that looks more like a question, not an answer.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
