Hi,
I'm not sure if this is the right place.
I understand there is a tool called MSDE web admin which is supposely a web based version of our fav MS SQL GUI tools. But that requires installation.
The reason im asking this is because currently we are doing a project in which client's IT side do not allow remote connection into their MS SQL server due to security concerns.
Problem is whenever we develop scripts/apps for them, we have to send the raw scripts and stored proc via email.
Whenever there are any bug fixes or column changes, we have to resend the changes to them and they have to alter the objects again.
So, I'm thinking whether are there any phpmyadmin clones which I can simply upload to the web server and do the data modifications/ column modifications / sp modifications ourselves.
Please advise. Thanks 9 3586
On Apr 20, 5:48 am, "Eric Layman" <namyalcire[at no spam]gmail.com>
wrote:
Hi,
I'm not sure if this is the right place.
I understand there is a tool called MSDE web admin which is supposely a web based version of our fav MS SQL GUI tools. But that requires installation.
The reason im asking this is because currently we are doing a project in which client's IT side do not allow remote connection into their MS SQL server due to security concerns.
Problem is whenever we develop scripts/apps for them, we have to send the raw scripts and stored proc via email.
Whenever there are any bug fixes or column changes, we have to resend the changes to them and they have to alter the objects again.
So, I'm thinking whether are there any phpmyadmin clones which I can simply upload to the web server and do the data modifications/ column modifications / sp modifications ourselves.
Please advise. Thanks
ASP.NET Enterprise Manager http://sourceforge.net/projects/asp-ent-man/
Alexey wrote on 19 Apr 2007 23:33:59 -0700:
On Apr 20, 5:48 am, "Eric Layman" <namyalcire[at no spam]gmail.com>
wrote:
>Hi,
I'm not sure if this is the right place.
I understand there is a tool called MSDE web admin which is supposely a web based version of our fav MS SQL GUI tools. But that requires installation .
The reason im asking this is because currently we are doing a project in which client's IT side do not allow remote connection into their MS SQL server due to security concerns.
Problem is whenever we develop scripts/apps for them, we have to send the raw scripts and stored proc via email.
Whenever there are any bug fixes or column changes, we have to resend the changes to them and they have to alter the objects again.
So, I'm thinking whether are there any phpmyadmin clones which I can simply upload to the web server and do the data modifications/ column modification s / sp modifications ourselves.
Please advise. Thanks
ASP.NET Enterprise Manager http://sourceforge.net/projects/asp-ent-man/
Not only does this appear to be no longer being developed (last updates are
2002), but I've had the unfortunate experience of actually having to use it
on a recent project. It's bug ridden, and a nightmare to have to use.
Most frustrating is the inability to be able to export a script (such as for
creating or altering tables, or indexes) from SQL EM or SMSS and run it in
ASP.NET EM - every time I've done this it does nothing.
Making changes to tables is painful - it took me a while to work out that
all the errors I got due to existing _temp tables was because it has a
problem when there is a PK on the table, I had to untick the PK and save,
then make the changes and save, then tick the PK again and save.
I'm in the process of trying to get the host using ASP.NET EM to install
Visual WebGUI Enterprise Manager
( http://sourceforge.net/projects/vwg-ent-man) which looks to pretty much
replicate SQL EM, and is the only other SQL web admin I've come across since
trying to find a replacement for ASP.NET EM.
Dan
On Apr 20, 10:33 am, "Daniel Crichton" <msn...@worldof spack.com>
wrote:
Alexey wrote on 19 Apr 2007 23:33:59 -0700:
On Apr 20, 5:48 am, "Eric Layman" <namyalcire[at no spam]gmail.com>
wrote:
Hi,
I'm not sure if this is the right place.
I understand there is a tool called MSDE web admin which is supposely a
web based version of our fav MS SQL GUI tools. But that requires
installation.
The reason im asking this is because currently we are doing a project in
which client's IT side do not allow remote connection into their MS SQL
server due to security concerns.
Problem is whenever we develop scripts/apps for them, we have to send the
raw scripts and stored proc via email.
Whenever there are any bug fixes or column changes, we have to resend the
changes to them and they have to alter the objects again.
So, I'm thinking whether are there any phpmyadmin clones which I can
simply upload to the web server and do the data modifications/ column
modifications / sp modifications ourselves.
Please advise. Thanks
ASP.NET Enterprise Manager http://sourceforge.net/projects/asp-ent-man/
Not only does this appear to be no longer being developed (last updates are
2002), but I've had the unfortunate experience of actually having to use it
on a recent project. It's bug ridden, and a nightmare to have to use.
Most frustrating is the inability to be able to export a script (such as for
creating or altering tables, or indexes) from SQL EM or SMSS and run it in
ASP.NET EM - every time I've done this it does nothing.
Making changes to tables is painful - it took me a while to work out that
all the errors I got due to existing _temp tables was because it has a
problem when there is a PK on the table, I had to untick the PK and save,
then make the changes and save, then tick the PK again and save.
I'm in the process of trying to get the host using ASP.NET EM to install
Visual WebGUI Enterprise Manager
(http://sourceforge.net/projects/vwg-ent-man) which looks to pretty much
replicate SQL EM, and is the only other SQL web admin I've come across since
trying to find a replacement for ASP.NET EM.
Dan- Hide quoted text -
- Show quoted text -
I was using the ASP.NET EM with a couple of hosting providers (was
installed by default) and had no big problems with it... A lack of
export could be a problem (I agree), however, from my opinion all
changes in the db-structure should be done on your local/development
server.
Visual WebGUI Enterprise Manager looks good, I need to try it.
But there is just one(?) snag
Quote: "The VEM requires ".wgx" script map to be registered in IIS." http://sourceforge.net/docman/displa...roup_id=168612
which in most cases cannot be done on remote server
Eric: why don't you make a simple ASPX-page with just a text field and
submit button. Using that page you can execute any script (assuming
you have a dbo access) against the database.
Alexey wrote on 20 Apr 2007 02:05:42 -0700:
On Apr 20, 10:33 am, "Daniel Crichton" <msn...@worldof spack.com>
wrote:
I was using the ASP.NET EM with a couple of hosting providers (was
installed by default) and had no big problems with it... A lack of
export could be a problem (I agree), however, from my opinion all
changes in the db-structure should be done on your local/development
server.
But how do I then get that db structure change onto the remote server? I was
developing a database for a client - their hosting provider only has this
ASP.NET EM to allow access to the SQL database, so as changes are made to my
local IIS and SQL setup (all testing is done on my own systems prior to
uploading to the client's site) there was no way I could get them onto the
remote SQL Server other than via this ASP.NET EM ...
Visual WebGUI Enterprise Manager looks good, I need to try it.
But there is just one(?) snag
Quote: "The VEM requires ".wgx" script map to be registered in IIS." http://sourceforge.net/docman/displa...roup_id=168612
which in most cases cannot be done on remote server
I'm hoping that as the client I'm working for has a few dedicated servers
with the host that they might be able to swing this.
Dan
On Apr 20, 11:20 am, "Daniel Crichton" <msn...@worldof spack.com>
wrote:
>
But how do I then get that db structure change onto the remote server? I was
Using SQL-query window
CREATE TABLE...
ALTER TABLE...
etc.
Alexey wrote on 20 Apr 2007 02:41:01 -0700:
On Apr 20, 11:20 am, "Daniel Crichton" <msn...@worldof spack.com>
wrote:
>> But how do I then get that db structure change onto the remote server? I was
Using SQL-query window
CREATE TABLE...
ALTER TABLE...
etc.
Which as I said, I tried and failed miserably, it just ignored the commands
I'd exported from EM/SMSS. I had no trouble with modifying data, but the
structure changes wouldn't work using T-SQL.
Dan
On Apr 20, 11:51 am, "Daniel Crichton" <msn...@worldof spack.com>
wrote:
Alexey wrote on 20 Apr 2007 02:41:01 -0700:
On Apr 20, 11:20 am, "Daniel Crichton" <msn...@worldof spack.com>
wrote:
But how do I then get that db structure change onto the remote server? I
was
Using SQL-query window
CREATE TABLE...
ALTER TABLE...
etc.
Which as I said, I tried and failed miserably, it just ignored the commands
I'd exported from EM/SMSS. I had no trouble with modifying data, but the
structure changes wouldn't work using T-SQL.
Dan
Ah, I think, I remember it. There was an annoying problem in EM, it
returned no error when a query was wrong, or an execution has failed.
open source is open source :-)
On Apr 19, 8:48 pm, "Eric Layman" <namyalcire[at no spam]gmail.com>
wrote:
The reason im asking this is because currently we are doing a project in which client's IT side do not allow remote connection into their MS SQL server due to security concerns.
So, I'm thinking whether are there any phpmyadmin clones which I can simply upload to the web server and do the data modifications/ column modifications / sp modifications ourselves.
Classic.
- Client is worried about security, so they lock down remote access to
the SQL Server.
- Consultant is annoyed with all this security
- Consultant installs tool allowing public web admin access to SQL
Server
Look, for better of for worse, your client wants his server locked
down. You should probably consider the possibility that bypassing
their intentions might be a bad idea. I'd suggest you package up your
change scripts and email them as you've been doing, and stop poking
holes in their security.
Just be sure to bill your time by the hour!
Jason Kester
Expat Software Consulting Services http://www.expatsoftware.com/
---
Get your own Travel Blog, with itinerary maps and photos! http://www.blogabond.com/
I'd suggest you package up your
change scripts and email them as you've been doing, and stop poking
holes in their security.
Or perhaps use: http://www.microsoft.com/downloads/d...DisplayLang=en
--
Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
"Jason Kester" <ja*********@gm ail.comwrote in message
news:11******** *************@d 57g2000hsg.goog legroups.com...
On Apr 19, 8:48 pm, "Eric Layman" <namyalcire[at no spam]gmail.com>
wrote:
>The reason im asking this is because currently we are doing a project in which client's IT side do not allow remote connection into their MS SQL server due to security concerns.
So, I'm thinking whether are there any phpmyadmin clones which I can simply upload to the web server and do the data modifications/ column modifications / sp modifications ourselves.
Classic.
- Client is worried about security, so they lock down remote access to
the SQL Server.
- Consultant is annoyed with all this security
- Consultant installs tool allowing public web admin access to SQL
Server
Look, for better of for worse, your client wants his server locked
down. You should probably consider the possibility that bypassing
their intentions might be a bad idea. I'd suggest you package up your
change scripts and email them as you've been doing, and stop poking
holes in their security.
Just be sure to bill your time by the hour!
Jason Kester
Expat Software Consulting Services http://www.expatsoftware.com/
---
Get your own Travel Blog, with itinerary maps and photos! http://www.blogabond.com/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: JimC |
last post by:
I have PHP installed on a Windows XP platform using IIS as
server. When updating a MySQL database field set to MEDIUMTEXT
in phpMyAdmin, the transaction seems to fail if the text contains
more than a few hundred characters.
The update is actually made successfully, but afterwards, the server
cannot locate the phpMyAdmin page as requested by the client
browser. I get a "Page cannot be found" error. Clicking
on Update from the browser...
|
by: SCS |
last post by:
Running PHP 4.5.7
PHPMyAdmin 2.5.7-pl1
IIS 6
I am thrying to get phpmyadmin to work, but whenever I click a link or try
to browse a database I get a 404 error, because the PmaAbsoluteUri
auto-detection is nor working properly.
Im pretty sure it is a problem with my php.ini file, but Im not sure where
to look... can someone please help
|
by: Stefan Mueller |
last post by:
I've just installed phpMyAdmin.
If I have the line
$cfg = 'http://localhost/php/phpmyadmin';
in my config.inc.php I can login to phpMyAdmin without any problems from my
local machine. But it's not working from the Internet.
To access it from the Internet I have modify the line
$cfg = 'http://www.myserver.com/php/phpmyadmin';
|
by: Daniel Mercier |
last post by:
Hi,
I'm new to mysql and just installed phpmyadmin.
Here is the versions info:
System Linux linlyne.spider.sense 2.4.22-1.2199.nptl #1
PHP Version 4.3.8
|
by: Christian Hansen |
last post by:
Can phpMyAdmin be used to manage databases that are not local?
| |
by: Dave Moore |
last post by:
Hi All,
I'm putting a website together using PHP and a MySQL database. I've been
using phpMyAdmin as it makes updating the DB nice and easy. For development,
I've been using Apache, MySQL and PHP installed on my local machine but now
I'm having problems porting to my hoster's server.
To transfer the database contents, I've exported the structure and data of
my local DB to a .sql file and uploaded this to my hosted DB using
phpMyAdmin on...
|
by: Marcus |
last post by:
Hello,
I am having a problem with a query in phpMyAdmin... it works fine on my
localhost, but the exact same query produces an error in phpMyAdmin on
my server:
localhost: PHP 4.3.11, MySQL 4.1.12, phpMyAdmin 2.8.1
server: PHP 4.3.11, MySQL 4.1.12, phpMyAdmin 2.6.3-pl1
SELECT AES_DECRYPT(pass, 'asdf') FROM `test`
|
by: pfletch750 |
last post by:
I am running Vista Ultimate on a Asus P5LD2 motherboard with a 2.8 GHz Intel D CPU, 3 GB of memory and lots of disk space. No problems with other applications or services. IIS 7.0 is installed and running, and I can browse to files in inetpub/wwwroot.
I have just installed PHP 4.4.7 (this is for testing and the target server doesn't support 5.x) and the latest version of MySQL (5.0.37). Both seem to be working properly. Browsing a test file...
|
by: seanh |
last post by:
Hi all,
I need some advice regarding phpmyadmin, I installed phpmyadmin directory in the htdocs but when I go to my http://mysite.com/phpmyadmin I get a 500 internal error. I checked the files from phpMyAdmin-3.1.3.2-english that I unziped on my desktop and compared each one to the ftp phpmyadmin directory files on the server so all files are all there. I also added config.inc.php file and put it inside phpmyadmin directory. I was wondering...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |