Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Help me make my mind up- sql or access Expand / Collapse
Author
Message
Posted Sunday, September 16, 2012 3:02 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 12, 2013 7:25 AM
Points: 39, Visits: 144
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.
Post #1359918
Posted Sunday, September 16, 2012 3:17 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 35,366, Visits: 31,905
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
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1359920
Posted Sunday, September 16, 2012 3:39 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 12, 2013 7:25 AM
Points: 39, Visits: 144
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.
Post #1359922
Posted Sunday, September 16, 2012 3:45 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 35,366, Visits: 31,905
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
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1359923
Posted Sunday, September 16, 2012 4:10 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 12, 2013 7:25 AM
Points: 39, Visits: 144
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.
Post #1359927
Posted Sunday, September 16, 2012 8:34 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 35,366, Visits: 31,905
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
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1359951
Posted Sunday, September 16, 2012 10:21 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:59 PM
Points: 7,105, Visits: 15,445
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?
Post #1359962
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse