Solved

MS SQL Express Resources

Posted on 2013-06-01
6
276 Views
Last Modified: 2013-06-02
I'm looking to migrate a bunch of Access (.accdb) back ends up to MS SQL Express. I am sure there is some book out there that includes a disk with the basic MS SQL Express software including whatever would stand in for all of the other database tools I am used to having in Access - the ability to view the tables, create queries or "stored proceedures" yada, yada, yada.

I tried to download this stuff from the Microsoft site and stuck with the 2008 version as I am not sure all of my client PCs are capable of handling 2012. But I ended up with a bunch of stuff that did not make much sense. I'd like something vanilla that I can work through at a comfortable pace.

Any suggestions will be appreciated.

Thanks!
0
Comment
Question by:Buck_Beasom
  • 3
  • 2
6 Comments
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 39213792
SSMS SQL Server Management Studio http://www.microsoft.com/en-us/download/details.aspx?id=7593 is the tool provided by Microsoft.  But SQL Server is not nearly as friendly as Access.  It doesn't "just work", it has to be set up, privileges granted, and access setup in both the server and the SQL Native Client.

On the other hand, it is a server and is much more powerful and multi-user than Access even can be.  You will probably only need one server that you can connect the Access front-ends to.  SQL Native Client will be needed on all clients in order to communicate with the server.  That way the users will still see Access and only you will have to deal with the server.
0
 

Author Comment

by:Buck_Beasom
ID: 39214776
Thank you for the reply. I went to the site and downloaded the application, twice, actually, as I am on Windows 7 and had to go get the service pack.

Here is my issue. (And you already have the 500 points, so don't worry.) I need to learn how to use this thing with basic functionality on my own time and on my own computer. So I need to setup something where I can mimic a Client/Server architecture locally.

My needs are relatively simple: Forms with a maybe a dozen basic controls, the ability to pull record sets and create database and Excel objects and manipulate them. That's about it. My problem is that the amount of data I am handling is so large that I need something with more horsepower than the Access .accdb format provides.

I once taught myself VB 2010 with a book, a disk and a few weeks getting questions answered from EE Experts. Maybe I am naive, but I'd like to think I can get there with at least the Express version of MS SQL. Any resources you can direct me to will be appreciated. I'll accept your next answer for full points.

Thanks again.
0
 
LVL 82

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 39214790
The Express version is what is used and/or provided with Visual Studio Express.  http://www.microsoft.com/visualstudio/eng/products/visual-studio-express-products   Between VS2012 and SSMS, you can get it done.  But a lot of things you learned in Access will have to be relearned, at least in the details, with SQL Server.  While they both are database programs, they are quite different in how they go about things.  Access is a desktop Office program mostly intended for a single user.  SQL Server is for multi-user thru front-ends from Access or another program, either like SSMS or something that you write.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Closing Comment

by:Buck_Beasom
ID: 39214970
Thank you for your kind responses. I've been designing multi-user Access and VB 2010 applications to talk to back end .accdb or .mdb databases for most of the last 10 years, but so far my attempts to pull down the MS SQL Express system (2008 version) have been a frustration clinic. I go through all of the processes and everything comes back "success" but when I actually try to launch I get all kinds of errors.

I can keep a tourniquet around things with regular .accdb back end files for a while. Meanwhile, I am going to take a run at MYSQL as an alternative. I would prefer to use a Microsoft product - as linking a Microsoft Front End with a Microsoft Back End makes the most intuitive sense as opposed to using an ODBC link. But I don't have the time, resources or support network to get into something that has "multiple registry hives" and all that stuff. My user population is never going to go above about a dozen. I just need something that can handle, say, 5 GB rather than 1.5 GB on the database end. I don't have the resources to have a dedicated Database Administrator, Object Librarian or all of that stuff.

Anyway, thanks for your insights. If you care to communicate off line, feel free to contact me at buckbeasom at aol. You seem to know your stuff. I'm just an ex CFO, middle school teacher, author and a bunch of other stuff who has learned how to survive in resource-poor environments.

Thanks again!
0
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 39214991
SQL Server Express appears to be limited to 4GB (per database?), regular SQL Server may be 10GB.  I don't know what you mean by "multiple registry hives".  I have SQL Server Express running on 4 computers here, 3 copies of SQL Express 2005 and 1 of SQL Express 2008, and I never had to deal with anything like that.  I use ASP and PHP to talk to them.  I can even connect to them from Linux though that is an old and somewhat crippled interface.

I find MySQL slightly easier than MS SQL but they are essentially the same.  MS SQL requires more detail to get it running but both are going to require you to set up users and user privileges to connect and access the databases.  There is no generic desktop access to them at any time.  All the SQL servers I know of are like that.

If you have further questions, please ask them here on Experts Exchange.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39215120
SQL Server Express appears to be limited to 4GB (per database?), regular SQL Server may be 10GB.
The maximum size for a database was increased from 4GB to 10GB with SQL Server 2008-R2 Express Edition.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
PL/SQL query 14 40
separate column 24 20
SQL 2016 Setup - Connectivity Issues 4 14
Create calculation and case in query with times 13 10
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now