473,842 Members | 1,804 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Web hosting and SQL Server Enterprise Manager?

Do you guys have any idea if web hosting companies usually give access to
SQL Server databases through Enterprise Manager?
I used to have have access to my DB through EE with my previous provider and
now the more I am looking into offers on the net the less I can see this
feature specified.

What can I do without EE to backup my database in a completely automated
way? Can I assume SQLDMO will always be available so that I can backup the
database myself without hardcoding the table structure in my scripts (I'll
be doing some ASP.NET)?

Thank you.

Nov 19 '05 #1
7 2367
John wrote:
Do you guys have any idea if web hosting companies usually give
access to SQL Server databases through Enterprise Manager?
I used to have have access to my DB through EE with my previous
provider and now the more I am looking into offers on the net the
less I can see this feature specified.

What can I do without EE to backup my database in a completely
automated way? Can I assume SQLDMO will always be available so that I
can backup the database myself without hardcoding the table structure
in my scripts (I'll be doing some ASP.NET)?

Thank you.


Depends entirely on your hosting plan. To be honest, it's probably
better you don't have SQL EM access because that would mean the hosting
company has exposed SQL Server to the internet. And that might be
considered a security problem. Most low-fee hosting plans (read: shared
hosting) do not give users the ability to back up databases if it's
hidden behind the web server. They usually provide rudimentary means to
access the server, but backups are performed by the hosting company
daily, weekly, monthly, or never.

In any case, you probably won't have SQL EM access. More likely you'll
use the Web Data Administrator. I've not seen a hosting company that
provides the SQL Server Client Tools as an local installation option,
but they may exist.

The question you raise is a concern. Depending on what you're doing with
SQL Server, you may be able to keep a local SQL Server copy and update
the web SQL Server when needed. If updates occur on the web site's SQL
Server, you need to check with your hosting company to see the options
you have for backup.

--
David Gugick
Imceda Software
www.imceda.com

Nov 19 '05 #2
I'm not sure if hosters generally grant access - but I know at least a
few that do. SQLDMO might also be a problem if the hosting company
gives your applications less than full trust.

You can do all this stuff (including backups) with T-SQL.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Tue, 5 Apr 2005 09:53:27 +1200, "John" <so******@somew here.com>
wrote:
Do you guys have any idea if web hosting companies usually give access to
SQL Server databases through Enterprise Manager?
I used to have have access to my DB through EE with my previous provider and
now the more I am looking into offers on the net the less I can see this
feature specified.

What can I do without EE to backup my database in a completely automated
way? Can I assume SQLDMO will always be available so that I can backup the
database myself without hardcoding the table structure in my scripts (I'll
be doing some ASP.NET)?

Thank you.


Nov 19 '05 #3
"Scott Allen" <sc***@nospam.o detocode.com> wrote in message
news:4l******** *************** *********@4ax.c om...
I'm not sure if hosters generally grant access - but I know at least a
few that do. SQLDMO might also be a problem if the hosting company
gives your applications less than full trust.

You can do all this stuff (including backups) with T-SQL.


What are my options exactly to create and drop tables programmaticall y
really?

1) SQLDMO. As you say, maybe it's disabled by default.
2) Creating a stored procedure with CREATE TABLE and DROP TABLE statements.
Is it what you mean and do you think my provider is likely to have this
feature disabled?

Nov 19 '05 #4
"David Gugick" <da***********@ imceda.com> wrote in message
news:OM******** ******@TK2MSFTN GP12.phx.gbl...
John wrote:
Do you guys have any idea if web hosting companies usually give
access to SQL Server databases through Enterprise Manager?
I used to have have access to my DB through EE with my previous
provider and now the more I am looking into offers on the net the
less I can see this feature specified.

What can I do without EE to backup my database in a completely
automated way? Can I assume SQLDMO will always be available so that I
can backup the database myself without hardcoding the table structure
in my scripts (I'll be doing some ASP.NET)?

Thank you.


Depends entirely on your hosting plan. To be honest, it's probably better
you don't have SQL EM access because that would mean the hosting company
has exposed SQL Server to the internet. And that might be considered a
security problem. Most low-fee hosting plans (read: shared hosting) do not
give users the ability to back up databases if it's hidden behind the web
server. They usually provide rudimentary means to access the server, but
backups are performed by the hosting company daily, weekly, monthly, or
never.

In any case, you probably won't have SQL EM access. More likely you'll use
the Web Data Administrator. I've not seen a hosting company that provides
the SQL Server Client Tools as an local installation option, but they may
exist.

The question you raise is a concern. Depending on what you're doing with
SQL Server, you may be able to keep a local SQL Server copy and update the
web SQL Server when needed. If updates occur on the web site's SQL Server,
you need to check with your hosting company to see the options you have
for backup.


Well I will work locally mostly. Create, drop and alter my tables probably
quite often, at least in the first months of the development.
If I have got to reflect manually the changes through the web interface of
the provider, that will be no good...
With Enterprise Manager, I would just backup my local database in a file.
Then connect to the remote server, drop the database and restore it from the
backup file.

I probably can live without EE, but only if I have a way to programmaticall y
create or drop database tables. I guess I'll have to ask the different
providers what my options are.


Nov 19 '05 #5
John wrote:
CREATE TABLE and DROP TABLE statements.
Realistically, you should be keeping change scripts for all your DB
changes. Enterprise Manager will generate them for you if you'd like.
It makes life so much easier when it comes to deploying your
applications. Just run all the scripts since the last push, and you're
done.
Is it what you mean and do you think my provider is likely to have this feature disabled?


I would be surprised if your hosting provider gave you an SQL server
account that did not have CREATE and DROP priviledges.

Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/

Nov 19 '05 #6
If you are serious about a service provider that will provide EE access I
know one but I am not going to broadcast it here. Send an email to
ru******@verizo n.net
"John" <so******@somew here.com> wrote in message
news:eE******** ******@TK2MSFTN GP12.phx.gbl...
Do you guys have any idea if web hosting companies usually give access to
SQL Server databases through Enterprise Manager?
I used to have have access to my DB through EE with my previous provider and now the more I am looking into offers on the net the less I can see this
feature specified.

What can I do without EE to backup my database in a completely automated
way? Can I assume SQLDMO will always be available so that I can backup the
database myself without hardcoding the table structure in my scripts (I'll
be doing some ASP.NET)?

Thank you.

Nov 19 '05 #7
Hi John:

You can always pump scripts into SQL Server using SqlConnection and
ExecuteNonQuery with SqlCommand from the .NET framework.

Generally, you'll be database owner (dbo) in your hosted database and
will be able to execute any of the DDL you need.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Tue, 5 Apr 2005 11:12:27 +1200, "John" <so******@somew here.com>
wrote:
"Scott Allen" <sc***@nospam.o detocode.com> wrote in message
news:4l******* *************** **********@4ax. com...
I'm not sure if hosters generally grant access - but I know at least a
few that do. SQLDMO might also be a problem if the hosting company
gives your applications less than full trust.

You can do all this stuff (including backups) with T-SQL.


What are my options exactly to create and drop tables programmaticall y
really?

1) SQLDMO. As you say, maybe it's disabled by default.
2) Creating a stored procedure with CREATE TABLE and DROP TABLE statements.
Is it what you mean and do you think my provider is likely to have this
feature disabled?


Nov 19 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
24297
by: David Gray | last post by:
Hello all, Having problems connecting to an Oracle 9i database from within SQL/Server 2000 using the Security/Linked Servers feature. Server1 (SQL/Server) ----------- Windows Server 2003, Standard edition MS SQL/Server 2000 Oracle 9i Client kit (OLEDB & ODBC) & Enterprise management tools
48
3735
by: ik | last post by:
ERROR after uninstalling SQL Server 2005 Express I get this message, SQLDMO has not been registered. Please re-run your setupand contact your system administrator. GREAT!!! ReInstalled SQL SERVER 2000 after playing around with SQL Server 2005...
3
1577
by: Jo Davis | last post by:
www.shanje.com does sql server hosting, on shared servers, at a reasonable price. It seems. They also allow client connections. Just playing around I've managed to connect an Access Data Project to a SQL Server database, and to access the database from Enterprise Manager (running locally). First of all - what does anybody think of that as a general idea - local client, connecting to MS SQL Server running on a shared host, connecting...
1
6646
by: mikew | last post by:
I am working at a company that has been using MS SQL Server, and we are going to be switching over to postgresql next week. (Getting off of Windows will be a relief!) I am very familiar with SQL Server's "Enterprise Manager", which is their GUI for accessing the db. I have been acquainting myself with pgAdmin. There are a number of things that I really like about pgAdmin, but there are a few things that SQL Server Enterprise manager can...
0
4552
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 , other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM , other IBM WebSphere Business CDs...
1
1230
by: Mazyad | last post by:
Dear Microsoft Developers Support ASP.NET Tea I have SQL DB has been created in web hosting support SQL server & ASP.NET and I develop on localhost web Application using ASP.NET After created SQL DB on web hosting I get this information * IP Address for the Server for example: 66.102.135.15 * DB name for example: Dynam * DB username for example: user * DB password for example: passwor
6
1397
by: Jon Vitar | last post by:
Can anyone suggest a reliable hosting provider? Our current provider has been experiencing a lot of down time lately. I'm looking for an ASP.NET hosting provider that: 1. allows remote SQL Server access using Enterprise Manager and Query Analyzer 2. high uptime 3. phone technical support (preferably)
2
2279
by: AH | last post by:
Dear all, I am facing this 'bug' that really drive me nut. I created a trigger for Update script and tested in Enterprise manager to ensure it function correctly. However, when I used both VB or Server explorer to update the table, it gives me error, Couldn't VB just act as a intermidary to make the call and SQL server is supposed to do all the jobs?? To explain it in a simple way, I have 3 TABLES, TABLE1 with column C1(key), C2(char) & C3...
7
1531
by: Brooke | last post by:
I am looking for some advice as to which hosting service to use for ASP.NET 2.0 and SQL Server development. I have looked at GoDaddy, BoundGrid, Interland and a few others but I still haven't made a decision. I also haven't been able to find a decent service that supports SQL 2005, most support SQL 2000 but claim that they are waiting for the bugs to be worked out of SQL Server 2005 before switching over. Here is what I am looking for;...
0
9865
marktang
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...
0
9709
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10668
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10303
tracyyun
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...
0
7025
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();...
0
5694
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...
1
4498
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
2
4085
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3140
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.