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 |
|
greaseman
Starting Member
30 Posts |
 Posted - 2006-10-26 : 15:55:06
|
| The outfit I work for has some applications that have MS Access databases that "feed" to SQL Server databases, using a lot of VB code. We're in the thinking / talking stages of getting everything into SQL Server (in short, get rid of the MS Access stuff completely). We'd also like to eliminate the VB code, if possible. What we want to end up having is everything in SQL Server, using stuff like stored procedures and so on.Questions: Is this doable? How about front-end screens? What about reports? Has anyone out there gone through this kind of potential effort? Any feed back would be so appreciated, including tools, utilities and what not to make the process easier.Thank you...looking forward to your answers!!!*********************************************************************This forum is best viewed with a computer. Questions asked freely. Confusion happily shared. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-26 : 16:04:52
|
| No this is not doable. You have to have a front-end application access SQL Server. You can use SQL Server Reporting Services for reports though. So you'll need to keep your VB code, but you can move all of the data and data access code into SQL Server.Tara Kizer |
 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-10-26 : 16:24:31
|
| It depends - what is the VB code doing? If it is presentation UI code, like taking a database field value and allowing the user to edit it, then you need to keep it in VB. If it is logic on the other hand - for example, if you have a VB procedure that accepts some values, checks them against certain rules, calculates some values and then uses the values to update a row in a database table, you could do all of that without VB, in a combination of stored procedures and constraints. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-26 : 16:47:30
|
| Well he did say "How about front-end screens?". You need VB for that or some other programming language.Tara Kizer |
|
|
|
greaseman
Starting Member
30 Posts |
Posted - 2006-10-27 : 11:37:58
|
| And I thank you all for your responses! That's kinda like what I figured, but wanted a bit of verification. Now to have the fun of digging in and figuring what I have to do! Guess that'll keep me out of trouble and off the streets for a while.Thanks again....I appreciate it!*********************************************************************This forum is best viewed with a computer. Questions asked freely. Confusion happily shared. |
|
|
|
|
|
|
|
|
Convert MS Access and VB to SQL Server