Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - SQL Server or Access?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL Server or Access?
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 12 February 2005 at 11:03am
If you want to build and test your SQL DB locally you can also install the MSDE version of SQL Server, MSDE short for Microsoft SQL Server Desktop Engine has limitations in how big a DB can be and how many concurrent connections it can process but for local development it is more then enough.
 
You can download MSDE here
 
Though MSDE does not come with Enterprise Manager, I learned to love another tool that is easier to operate and much faster anyway, the LITE version which is enough can be downloaded here for free.
http://www.sqlmanager.net/products/mssql/manager/download
Blog | MPG Tracker
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 13 February 2005 at 4:52pm
Originally posted by Ginger Ginger wrote:

Am I right in thinking that I can develop everything on my 'local' PC using the low priced (£37.00) Developers Edition of MS SQL Server, I then upload it to my hosting site, who have MS SQL Server installer on their server and their software takes care of everything else.
 
That's correct. As also noted above, you can used msde to develop locally as well. The SQL server developer edition is essentially MSDE plus tutorial (SQL Server Books Online), plus MS Enterprise Manager wich is an excellent tool fro transfering your local Developer DB to the Host as well as useful for a lot of admin tasks for both your developer and host ed versions of the DB.
 
INHO, geting MS Enterprise Manager (EM) is alone worth the price of the developer edition. There are other similar tools available, and some are free. However, every tutorial you run across for MS SQL server says things like "You then do X in EM , then you use the Y option to do Z in EM".

Lead me not into temptation... I know the short cut, follow me.
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 13 February 2005 at 8:13pm
Actually the Developer Edition is the Enterprise Edition with a different License so you can do clustering etc.
Personally I do not think that EM is worth a penny, the only client tool that basically never has been done in any freeware is DTS, thus dPyerys being right just for DTS I'd spent the money as it is an invaluable tool to transfer data.
Blog | MPG Tracker
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.