SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Help me make my mind up- sql or access


Help me make my mind up- sql or access

Author
Message
lonhanner
lonhanner
SSC-Enthusiastic
SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)

Group: General Forum Members
Points: 149 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.
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)

Group: General Forum Members
Points: 202990 Visits: 41947
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
lonhanner
lonhanner
SSC-Enthusiastic
SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)

Group: General Forum Members
Points: 149 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.
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)

Group: General Forum Members
Points: 202990 Visits: 41947
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
lonhanner
lonhanner
SSC-Enthusiastic
SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)SSC-Enthusiastic (149 reputation)

Group: General Forum Members
Points: 149 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.
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)SSC Guru (202K reputation)

Group: General Forum Members
Points: 202990 Visits: 41947
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Matt Miller (4)
Matt Miller (4)
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27792 Visits: 18995
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?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search