Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
masteripper
Starting Member
25 Posts |
 Posted - 2009-03-04 : 15:41:05
|
| I am thinking of transferring the existing application that my company uses from Access to SQL 2005 + VB2005.I have done a rather a lot of thinking and i have come with a rather strange idea due to the fact that the existing Access application is BIG(100MB are the programs alone and with NO fancy graphics)Well a big obstacle is the queries and in code queries so in order to avoid a lot of SQL Programming and to have a better organisation i am thinking the following scenario:1 Table with 3 fields1st ID2nd Group (e.g Sales like the Modules i have in Access)3rd the Queries in plain TextUsing VB i will retrieve the query text and execute it plain and simple with SqlCmd.Well what do u think..... |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-03-04 : 15:50:41
|
| sorry mp can you please repeat that again nice and clearly. I am not understanding your questions. |
 |
|
|
masteripper
Starting Member
25 Posts |
Posted - 2009-03-04 : 17:06:58
|
| Well i am thinking of avoiding the conversion of queries->stored procedures by using a single well organized table which has all the queries i need in one place and i am thinking if it is a bad idea or i would be no harm ot include it in my design |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-03-04 : 17:27:26
|
| IMHO as a temporary solution it is not a bad idea, it seems feasable as far as design approach but not sure if it will work technically. try it out with one or two queries and see if it works, see what is involved and then decide. but in the long run you will have to dive into SQL. why are you moving to SQL in the first place? |
|
|
|
|
|
|
Well a rather strange question/ idea