September 16, 2012 at 3:02 pm
I have a client to whom I am writing a database program for in vb.net 2010 express. They currently have an ACCESS 2010 database on their server share dir. It has 6 tables and several query. i would like to use sql, but they cannot afford SQL SERVER full ver. They also have 3 users. There are over 8000 records in the main detail table. I have several questions:
1-Can I use SQL EXPRESS 2008. If so, do I have to install sql express on the server and workstations.
2-Should I install .net4
3- Can I use in ACCESS, and migrate the data to a new sql database.
September 16, 2012 at 3:17 pm
lonhanner (9/16/2012)
I have a client to whom I am writing a database program for in vb.net 2010 express. They currently have an ACCESS 2010 database on their server share dir. It has 6 tables and several query. i would like to use sql, but they cannot afford SQL SERVER full ver. They also have 3 users. There are over 8000 records in the main detail table. I have several questions:1-Can I use SQL EXPRESS 2008. If so, do I have to install sql express on the server and workstations.
2-Should I install .net4
3- Can I use in ACCESS, and migrate the data to a new sql database.
How many connections to the database do you expect at any one time and to what size do you expect the database to grow?
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2012 at 3:39 pm
There will be 3 to 4 users and the could be accessing the database and tables all at the same time.
BTW I am very new in sql and vb.net 2010. I am old school VB6.
September 16, 2012 at 3:45 pm
lonhanner (9/16/2012)
There will be 3 to 4 users and the could be accessing the database and tables all at the same time.BTW I am very new in sql and vb.net 2010. I am old school VB6.
It was a two part question. You've answered the first part. The second part was how big do you expect the database to grow?
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2012 at 4:10 pm
Jeff The size now is 35MB this is over 10 years of data. I do not know for sure. I just took this job because I don.t have work. I lost my job because of plant closing. I worte vb6 programs collecting data on the shop floor. We used Access as a database. I am writting the hard way learn as I go. I have 3 months to do it. Just thought i would give you and others some back ground. I am moving form VB6 to .net 2010 express. Wanting to move away from ACCESS if I can. I also need to know what tools I need for SQL 2008 Express. I have installed on my laptop running windows 7 home premium with 6gig ram but dont know how to use it the only option I have are: Import /export data and Configuration Tools.
September 16, 2012 at 8:34 pm
lonhanner (9/16/2012)
Jeff The size now is 35MB this is over 10 years of data. I do not know for sure. I just took this job because I don.t have work. I lost my job because of plant closing. I worte vb6 programs collecting data on the shop floor. We used Access as a database. I am writting the hard way learn as I go. I have 3 months to do it. Just thought i would give you and others some back ground. I am moving form VB6 to .net 2010 express. Wanting to move away from ACCESS if I can. I also need to know what tools I need for SQL 2008 Express. I have installed on my laptop running windows 7 home premium with 6gig ram but dont know how to use it the only option I have are: Import /export data and Configuration Tools.
I can't help on which .NET tools to use for SQL Server 2008 but, based on what you said above, either Access or SQL 2008 Express should work fine for this for a very long time. I just wanted to make sure you didn't have too many concurrent connections to the DB and that you weren't going to go over 4GB for a long time.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2012 at 10:21 pm
lonhanner (9/16/2012)
Jeff The size now is 35MB this is over 10 years of data. I do not know for sure. I just took this job because I don.t have work. I lost my job because of plant closing. I worte vb6 programs collecting data on the shop floor. We used Access as a database. I am writting the hard way learn as I go. I have 3 months to do it. Just thought i would give you and others some back ground. I am moving form VB6 to .net 2010 express. Wanting to move away from ACCESS if I can. I also need to know what tools I need for SQL 2008 Express. I have installed on my laptop running windows 7 home premium with 6gig ram but dont know how to use it the only option I have are: Import /export data and Configuration Tools.
It sounds like you didn't get the SQL Server Management Suite for Express. You will want that if you plan on building out view, stored procedures etc... (recommended).
That said - if you're dealing with basic operations (i.e. single table CRUD operations) on small tables, you might care to simply look over using things like datagrids or other such automation feature within .NET, which will largely automate building out those procedures and/or data access features you might need (for simple scenarios they're actually not bad).
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply