Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-28-2017, 04:27 AM   #1
aman
Newly Registered User
 
Join Date: Oct 2008
Posts: 1,085
Thanks: 43
Thanked 1 Time in 1 Post
aman is an unknown quantity at this point
SQL server express edition

Hi Guys

We have an application built in MS Access , we are now thinking to change it to web based app. So the backend will be changed to SQL server but as its licence is very costly so I gave my mangers suggestion of using SQL server express edition. Now I have some questions from my manager like if we are using sql server express edition then where the data will be stored?
Will the data be stored in our own mainframe or will it be cloud based?

Any help will be much appreciated.

Thanks

aman is offline   Reply With Quote
Old 07-28-2017, 04:33 AM   #2
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 2,051
Thanks: 37
Thanked 483 Times in 448 Posts
ridders will become famous soon enough ridders will become famous soon enough
Re: SQL server express edition

Since Access 2013, web app data has been stored in SharePoint online

However, Access web apps are being deprecated.
There is therefore NO point converting an Access desktop app to an AWA

Lots of online links about this e.g. https://blogs.technet.microsoft.com/...to-be-retired/
__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!

Last edited by ridders; 07-28-2017 at 04:42 AM. Reason: Added link
ridders is offline   Reply With Quote
Old 07-28-2017, 04:43 AM   #3
aman
Newly Registered User
 
Join Date: Oct 2008
Posts: 1,085
Thanks: 43
Thanked 1 Time in 1 Post
aman is an unknown quantity at this point
Re: SQL server express edition

Ridders , We will develop new frontend using .net framework. So the backend will be sql server and that's why my question is.

aman is offline   Reply With Quote
Old 07-28-2017, 04:44 AM   #4
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 2,051
Thanks: 37
Thanked 483 Times in 448 Posts
ridders will become famous soon enough ridders will become famous soon enough
Re: SQL server express edition

OK - in that case I can't advise you
__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!
ridders is offline   Reply With Quote
Old 07-28-2017, 04:46 AM   #5
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 9,508
Thanks: 36
Thanked 3,071 Times in 2,985 Posts
CJ_London is a jewel in the rough CJ_London is a jewel in the rough CJ_London is a jewel in the rough
Re: SQL server express edition

Do not underestimate the cost of developing a web based front end. Typically it will be around 10 times more expensive (in terms of time to develop) than Access.

You have to ask why you want to change to a web based app. It should only be for the reason of accessibility of the data from remote locations/machines with different OS.

Don't forget that access is two systems, a backend containing tables (and you don't have to use the Access ACE db engine, you can use sql server, MySQL or many others) and a front end containing the forms, code etc.
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 07-28-2017, 04:58 AM   #6
aman
Newly Registered User
 
Join Date: Oct 2008
Posts: 1,085
Thanks: 43
Thanked 1 Time in 1 Post
aman is an unknown quantity at this point
Re: SQL server express edition

CJ_London, I understand what you mean. If I need to convert the backend into more robust backend i.e. sql server, my question is can I use sql server express edition which is free of cost? If yes then where the data will be stored? Will it be stored within company mainframe or will it be cloud based?
aman is offline   Reply With Quote
Old 07-28-2017, 05:42 AM   #7
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 4,419
Thanks: 88
Thanked 1,205 Times in 1,179 Posts
Minty will become famous soon enough Minty will become famous soon enough
Re: SQL server express edition

That's up to you, you can host your own SQL server or get someone to host it for you.

__________________
A little thanks goes a long way
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

(Please use the scales on the left if we have helped!) Mark threads as Solved once you have an answer.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 07-28-2017, 06:02 AM   #8
ashleedawg
"Here for a good time"
 
ashleedawg's Avatar
 
Join Date: Jun 2017
Location: Canada
Posts: 150
Thanks: 18
Thanked 36 Times in 33 Posts
ashleedawg is on a distinguished road
Re: SQL server express edition

SQL Server Express stores data locally.

You can try it for free and if you decide that you need the full version of SQL Server, the data is easily transferred over.

Here's a quick overview of the options.
__________________
_______________________________________
Back in the Fire
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
ashleedawg is offline   Reply With Quote
Old 07-31-2017, 02:29 AM   #9
aman
Newly Registered User
 
Join Date: Oct 2008
Posts: 1,085
Thanks: 43
Thanked 1 Time in 1 Post
aman is an unknown quantity at this point
Re: SQL server express edition

I am working within a bank so just wondering if we get sql server express downloaded free of cost online then will the data be stored within our mainframe or we need to buy licence for sql server full edition?
Can anyone please explain it?
aman is offline   Reply With Quote
Old 07-31-2017, 02:50 AM   #10
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 4,419
Thanks: 88
Thanked 1,205 Times in 1,179 Posts
Minty will become famous soon enough Minty will become famous soon enough
Re: SQL server express edition

SQL Server whatever edition is a database backend. If that database is installed on a machine on your network, then by default that's where it is stored.

Be aware of the restrictions that the free edition has on storage and users, the link ashleedawg provided has other links to the exact conditions and usage structure.
__________________
A little thanks goes a long way
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

(Please use the scales on the left if we have helped!) Mark threads as Solved once you have an answer.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 07-31-2017, 02:57 AM   #11
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 2,051
Thanks: 37
Thanked 483 Times in 448 Posts
ridders will become famous soon enough ridders will become famous soon enough
Re: SQL server express edition

Just to add to the previous answers, I've been deploying SQL Server Express with an Access FE with a significant number of schools for over 8 years with the SQL datafiles stored on their school networks.

In all that time, none of the schools has even remotely approached the limitations of the free edition (10GB)

UPDATE:
I've just found out that the SQL Server Developers edition (2014 or 2016) is now a free download for Visual Studio Dev Essentials members (you will be prompted to sign in to Visual Studio Dev Essentials before you can download SQL Server 2014 Developer Edition).
See https://blogs.technet.microsoft.com/...n-is-now-free/

How this differs from the SQL Server Express edition, I'm not sure as I'm just in the process of downloading it myself
__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!

Last edited by ridders; 07-31-2017 at 04:17 AM.
ridders is offline   Reply With Quote
Old 07-31-2017, 04:47 AM   #12
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 10,794
Thanks: 58
Thanked 1,304 Times in 1,229 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: SQL server express edition

Quote:
Originally Posted by ridders View Post
I've just found out that the SQL Server Developers edition (2014 or 2016) is now a free download for Visual Studio Dev Essentials
How this differs from the SQL Server Express edition, I'm not sure as I'm just in the process of downloading it myself
It is everything. But it cannot be used for any production database.

It is for developers to make use of the fancy features then have their customers pay Microsoft bigtime. They used to charge a nominal small amount but I assume they found that giving it away was an even better result for them.
Galaxiom is offline   Reply With Quote
Old 07-31-2017, 04:52 AM   #13
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 2,051
Thanks: 37
Thanked 483 Times in 448 Posts
ridders will become famous soon enough ridders will become famous soon enough
Re: SQL server express edition

That's what I thought on reading about it.

Developers get used to using features only available in the paid versions & then encourage their clients to purchase the paid versions as well. Clever!

However to repeat my earlier point, none of my clients have outgrown SQL Server Express after 8 years and schools accumulate a lot of staff, student & whole school data

I'm also downloading Visual Studio Community Version 2017.
Same sort of approach from MS here.

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!
ridders is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server Express Edition DBinPhilly General 2 05-28-2013 02:06 PM
SQL Server 2008 Express Edition on Vista Rockape SQL Server 10 10-16-2010 07:56 AM
Database diagrams Visual basic 2008 Express Edition beeky VB.NET 0 03-11-2010 02:54 AM
SQL Server 2005 Workgroup Edition AnnPhil SQL Server 1 12-18-2006 03:37 PM
Sql Server 2005 Express Edition Support Multiple User jaydwest SQL Server 1 11-28-2006 09:03 AM




All times are GMT -8. The time now is 11:45 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World