Subject | Two database design |
---|---|
Author | kogerbnz |
Post date | 2007-10-15T20:02:49Z |
Hello
I have a design question for my application.
I'm going to make a Windows application that uses Firebird TODO:
embedded? and MSSQL server. I don't know either of the two databases
very well, AFAIK Firebird is more ANSI complient(TODO=).
Right now I'm wondering if it would best to make the SQL statements as
stored procedures or make a SQL statements module in the application.
I'm thinking that the last solution would be the best, because I will
only have to write the procedures once. I assume that the statements
for both databases will mostly be the same.
What do you think, did I forget something?
Thank you very much in advance,
Karsten
I have a design question for my application.
I'm going to make a Windows application that uses Firebird TODO:
embedded? and MSSQL server. I don't know either of the two databases
very well, AFAIK Firebird is more ANSI complient(TODO=).
Right now I'm wondering if it would best to make the SQL statements as
stored procedures or make a SQL statements module in the application.
I'm thinking that the last solution would be the best, because I will
only have to write the procedures once. I assume that the statements
for both databases will mostly be the same.
What do you think, did I forget something?
Thank you very much in advance,
Karsten