MS SQL 2000 on Webserver

Hi All,
I've completed my first website, and now I want to add database
functionality. I am familar with Access and VB. I have been using MS
Visual Web Dev Express to create the website.

I've bought some space with a hosting company who provide MS SQL 2000
Database functionality, and I've got MS SQL 2005 installed on my
machine.

I've managed to connect to the Web DB okay through the SQL 2005
management program, and I am able to create tables etc.

My questions are as follows:

To create tables, input data and generally administer the DB over the
internet is a slow and frustrating process. I am used to copying and
pasting with MS Access, which makes data inputting really quick because
I can use Excel to generate the data first.

1. Is there any way of creating the database on my local machine, and
then copy/sync with the web server copy? (- I am not able to remotely
create a database or use replication with the web server host, since to
create DBs I must be logged in to thier website.)

2. I ultimately intend to create a full e-commerce website, which won't
ever have as many users as say Amazon, but even so, am I right in
saying that it makes sense to create the DB in SQL 2000, since it will
be easily able to cope with heavy workloads in the future, as opposed
to me putting an Access DB on the web?

I've got some good books to help me, but none of them tackle the issues
of using a web based database system..... or am I simply using the
wrong software here??

Thanks in advance.

Hi

As you are using SQL Express, then you can only be a replication subscriber
and would need standard or enterprise edition on the local system to do this
see http://www.microsoft.com/sql/prodin...e-features.mspx for
features each edition supports. An alternative may be to either
backup/restore or detach/attach the database and copy those onto the web
server. SQL express can attach databases as part of the connection see
http://www.connectionstrings.com/? ...rver200
5 so you may not need
to explicitly attach the database (just stop/start the web site). If you
don't want to stop the web site during an upgrade you may want to
restore/attach the database as a separate database and then have a process
that updates the live database from that.

HTH

John

"ginozzzz@btclick.com" wrote:

> Hi All,
> I've completed my first website, and now I want to add database
> functionality. I am familar with Access and VB. I have been using MS
> Visual Web Dev Express to create the website.
>
> I've bought some space with a hosting company who provide MS SQL 2000
> Database functionality, and I've got MS SQL 2005 installed on my
> machine.
>
> I've managed to connect to the Web DB okay through the SQL 2005
> management program, and I am able to create tables etc.
>
> My questions are as follows:
>
> To create tables, input data and generally administer the DB over the
> internet is a slow and frustrating process. I am used to copying and
> pasting with MS Access, which makes data inputting really quick because
> I can use Excel to generate the data first.
>
> 1. Is there any way of creating the database on my local machine, and
> then copy/sync with the web server copy? (- I am not able to remotely
> create a database or use replication with the web server host, since to
> create DBs I must be logged in to thier website.)
>
> 2. I ultimately intend to create a full e-commerce website, which won't
> ever have as many users as say Amazon, but even so, am I right in
> saying that it makes sense to create the DB in SQL 2000, since it will
> be easily able to cope with heavy workloads in the future, as opposed
> to me putting an Access DB on the web?
>
> I've got some good books to help me, but none of them tackle the issues
> of using a web based database system..... or am I simply using the
> wrong software here??
>
> Thanks in advance.
>
>

Thanks John, but as I mentioned in my posting, I do actually have a
full copy of MS SQL 2005 running on my machine, and I'm using it to
handle an SQL 2000 DB on my hosts website.... so where does this leave
me?

Thanks

Sorry John... I forgot to add that I don't seem to be able to copy a DB
onto the web server.  I have had to create the DB online using their
management interface, and then I'm given the login details to use with
my front-end software/GUI.

Also, any ideas on why there's such a lack of information on this
subject? Are there any websites that go into depth with this kind of
databasing??

Is there any way of creating the database on my local machine, and
then copy/sync with the web server copy?

You should be able tol use Excel to create the data as well as copy
from your 2005 to the hosted 2K server as long as as you have a DTS
package create the tables.

I am not sure if that answers your question.

Regards,
H

> Hi All,
> I've completed my first website, and now I want to add database
> functionality. I am familar with Access and VB. I have been using MS
> Visual Web Dev Express to create the website.
>
> I've bought some space with a hosting company who provide MS SQL 2000
> Database functionality, and I've got MS SQL 2005 installed on my
> machine.
>
> I've managed to connect to the Web DB okay through the SQL 2005
> management program, and I am able to create tables etc.
>
> My questions are as follows:
>
> To create tables, input data and generally administer the DB over the
> internet is a slow and frustrating process. I am used to copying and
> pasting with MS Access, which makes data inputting really quick because
> I can use Excel to generate the data first.
>
> 1. Is there any way of creating the database on my local machine, and
> then copy/sync with the web server copy? (- I am not able to remotely
> create a database or use replication with the web server host, since to
> create DBs I must be logged in to thier website.)
>
> 2. I ultimately intend to create a full e-commerce website, which won't
> ever have as many users as say Amazon, but even so, am I right in
> saying that it makes sense to create the DB in SQL 2000, since it will
> be easily able to cope with heavy workloads in the future, as opposed
> to me putting an Access DB on the web?
>
> I've got some good books to help me, but none of them tackle the issues
> of using a web based database system..... or am I simply using the
> wrong software here??
>
> Thanks in advance.

Hi

Unless you provider gives you FTP access or possibly a VPN, then your
options are limited, for instance if FTP was possible then snapshot
replication via FTP or a manual distribution of backup/data files will be an
option.

You can read up on replication on MSDN or Books Online for example one
reference is http://msdn2.microsoft.com/en-us/library/ms151844.aspx

John

"Gee" wrote:

> Sorry John... I forgot to add that I don't seem to be able to copy a DB
> onto the web server.  I have had to create the DB online using their
> management interface, and then I'm given the login details to use with
> my front-end software/GUI.
>
> Also, any ideas on why there's such a lack of information on this
> subject? Are there any websites that go into depth with this kind of
> databasing??
>
>

Thanks to all.  For the benefit of the thread... I have managed to ask
the ISP about this, and they have told me that I only have DBA rights
when I create the database online, and that I'll need to FTP the DB to
my webspace, and ask them to attach it for me.

They will not give me full rights to access the server 'for obvious
reasons'.

Ho hum........

Hi

You are not likely to get full rights if this is a shared server, but the
cost for housing your own kit or having a dedicated server will be
significantly higher.

John

"Gee" wrote:

> Thanks to all.  For the benefit of the thread... I have managed to ask
> the ISP about this, and they have told me that I only have DBA rights
> when I create the database online, and that I'll need to FTP the DB to
> my webspace, and ask them to attach it for me.
>
> They will not give me full rights to access the server 'for obvious
> reasons'.
>
> Ho hum........
>
>