Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - SQL Server manage
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL Server manage

 Post Reply Post Reply Page  12>
Author
Roberto Randall View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 August 2009
Location: San Pedro Alc.
Status: Offline
Points: 260
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roberto Randall Quote  Post ReplyReply Direct Link To This Post Topic: SQL Server manage
    Posted: 13 December 2012 at 1:13pm

I propose an idea to make a new program:

It is necessary for everyone to have a quick and easy access to the databases "SQL Server" and "MySQL".

Whenever I want to create, delete or modify a table or field in one of my SQL Server database I have to create ASP code to do so. As happens to me will happen to many people.

If you make a program (web Asp) entering connection data database can be managed easily think that would very good sale.

https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2012 at 11:58am
Although most web based Database Managers for SQL Server are quite expensive, you do have SQL Server Manager Studio Express free from Microsoft to install on your desktop to manage SQL Server databases with.

With mySQL you have PhpMyAdmin which is a free web based Database management tool for managing mySQL databases with, which is pretty much industry standard now.
Back to Top
Roberto Randall View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 August 2009
Location: San Pedro Alc.
Status: Offline
Points: 260
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roberto Randall Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2012 at 6:24pm

SQL Server Management Studio Express must be installed on the server?

I need a program to install it on my pc. I have not the server.

Thanks,

https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat
Back to Top
IanSmithISA View Drop Down
Groupie
Groupie


Joined: 21 October 2010
Location: Worcester
Status: Offline
Points: 127
Post Options Post Options   Thanks (0) Thanks(0)   Quote IanSmithISA Quote  Post ReplyReply Direct Link To This Post Posted: 15 December 2012 at 8:03am
Good  morning

You can goto 

http://www.microsoft.com/en-gb/download/details.aspx?id=26729

and down SQL Server EXpress with tools.

Although this download will include the SQL Server database, when you do the install you can select the management tools only.

I have been managing my SQL Server databases this way since I started hosting here without any problems.

Bye

Ian
Why does anyone need more than an 80x25 character only VDU?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 15 December 2012 at 9:29am
You can also download SQL Server Management Studio on it's own to install on your PC:-

http://www.microsoft.com/en-gb/download/details.aspx?id=29062

You need to download either of the two below depending if you are running 64 or 32 bit versions of Windows:-

ENU\x64\SQLManagementStudio_x64_ENU.exe
ENU\x86\SQLEXPRWT_x86_ENU.exe
Back to Top
Roberto Randall View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 August 2009
Location: San Pedro Alc.
Status: Offline
Points: 260
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roberto Randall Quote  Post ReplyReply Direct Link To This Post Posted: 15 December 2012 at 9:47am
Thanks, I will download and set it up.
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat
Back to Top
Roberto Randall View Drop Down
Senior Member
Senior Member
Avatar

Joined: 21 August 2009
Location: San Pedro Alc.
Status: Offline
Points: 260
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roberto Randall Quote  Post ReplyReply Direct Link To This Post Posted: 15 December 2012 at 9:20pm
Sorry, I speak Spanish and do not quite understand. I present the installation screen. Please tell me what options I have to choose. Thank you.
 
 
https://www.lanocion.es - https://www.lanocion.games - https://www.lanocion.chat
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9791
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 17 December 2012 at 9:32am
I would uncheck the one for LocalDB as this is a new type of SQL Server database from Microsoft and you do not need to install this.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 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 Policy

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 unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

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