<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
Help me make my mind up- sql or access
Help me make my mind up- sql or access
Rate Topic
Display Mode
Topic Options
Author
Message
lonhanner
lonhanner
Posted Sunday, September 16, 2012 3:02 PM
SSC Rookie
Group: General Forum Members
Last Login: Friday, February 22, 2013 11:14 AM
Points: 39,
Visits: 141
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
Jeff Moden
Jeff Moden
Posted Sunday, September 16, 2012 3:17 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:51 PM
Points: 32,923,
Visits: 26,811
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 "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1359920
lonhanner
lonhanner
Posted Sunday, September 16, 2012 3:39 PM
SSC Rookie
Group: General Forum Members
Last Login: Friday, February 22, 2013 11:14 AM
Points: 39,
Visits: 141
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
Jeff Moden
Jeff Moden
Posted Sunday, September 16, 2012 3:45 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:51 PM
Points: 32,923,
Visits: 26,811
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 "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1359923
lonhanner
lonhanner
Posted Sunday, September 16, 2012 4:10 PM
SSC Rookie
Group: General Forum Members
Last Login: Friday, February 22, 2013 11:14 AM
Points: 39,
Visits: 141
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
Jeff Moden
Jeff Moden
Posted Sunday, September 16, 2012 8:34 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:51 PM
Points: 32,923,
Visits: 26,811
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 "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1359951
Matt Miller (#4)
Matt Miller (#4)
Posted Sunday, September 16, 2012 10:21 PM
SSCertifiable
Group: General Forum Members
Last Login: 2 days ago @ 7:57 PM
Points: 6,998,
Visits: 13,949
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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
