How do I get started talking to my webmatrix sql server

get a prompt up (in a program like telnet / msdos window) so that I can run sql commands on my webmatrix accounts sql server. I've been trying to connect using telnet but i think maybe I've got the wrong end of the stick or I'm doing something wrong.

here's a link where you click through "how to connect" on the "myserver page" I searched the page for "connect" and found 0 occurances.

http://europe.webmatrixhosting.net/text.aspx?tmpl=qa#3.7anyone please help,

the only way I know of to create table is through an sql prompt,

is there another way or can somebody give me some pointers cos i'm well stuck.|||Will webmatrixhosting let you use Enterprise Manager and Query Analyzer?|||i have windows XP pro, it doesn't come with it does it?

this isn't my main priority at the moment though,

trying to get an msde installed however is :

http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=447274

http://www.gotdotnet.com/Community/MessageBoard/Thread.aspx?id=181961&Page=1#183199

then I might actually be able to start coding the ASP.NET I'm required to produced (pretty much by the end of the week)|||Enterprise Manager and Query Analyzer are "free" tools provided with SQL Server 2k.
Even when demo period is over, you can still use 'em.

Install MSDE.
Download SQL Server 2k.
Then just choose "SQL Server Tools only" during install.|||wicked!

I was looking for a trial on the ms site but couldn't find one b4 - didn't think they had one, downloading it now :)

How do I do this is SQL Server? (from an Oracle background)

SQL Server 2000 Ent, PowerBuilder 6.5 Ent, Window 2000 Pro

Hi,

My only experience is with Oracle,so please bear with me...

We have some new clients that require our pricing data be imported
into their Sql Server databases. The price lists are in Excel files,
which we recieve from numerous vendors on a quarterly basis.

In Oracle we take the following steps:

1. Import this data into tempory tables using bulk import utility
called sqlLoader.

2. Then we have procedures that parse in the data to our various price
tables.

3. Next we export the tables to a '.dmp' file. (contains table data
and table definitions I think).

4. Then the clients download the .dmp file

5. Our client application is then used to drop the price tables on
their local db. and import the .dmp file.

Can anyone point me in the right direction by telling me how to
approach this using SQL Server?

Thanks,
KarenSorry subject should be "How do I do this IN SQL Server? dang laptop
keyboard..|||One approach in SQL Server is to use DTS. You could create 2 DTS packages
as follows:

DTS Package 1:

1. Import data into temporary tables using DTS Transform Data tasks. DTS
can import data directly from Excel.

2. Execute procedures to load various price tables.

3. Export tables to individual files (containing data only).

DTS Package 2:

1. Recreate price tables using DDL embedded in DTS package (or simply
truncate existing destination tables)

2. Import data into price tables

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Karen" <nowhere@.home.com> wrote in message
news:c3ui70pbbemclvu2cqv00fhgnd41lrj3pa@.4ax.com...
> SQL Server 2000 Ent, PowerBuilder 6.5 Ent, Window 2000 Pro
> Hi,
> My only experience is with Oracle,so please bear with me...
> We have some new clients that require our pricing data be imported
> into their Sql Server databases. The price lists are in Excel files,
> which we recieve from numerous vendors on a quarterly basis.
> In Oracle we take the following steps:
> 1. Import this data into tempory tables using bulk import utility
> called sqlLoader.
> 2. Then we have procedures that parse in the data to our various price
> tables.
> 3. Next we export the tables to a '.dmp' file. (contains table data
> and table definitions I think).
> 4. Then the clients download the .dmp file
> 5. Our client application is then used to drop the price tables on
> their local db. and import the .dmp file.
> Can anyone point me in the right direction by telling me how to
> approach this using SQL Server?
> Thanks,
> Karen|||Thanks Dan.

On Mon, 12 Apr 2004 02:21:12 GMT, "Dan Guzman"
<danguzman@.nospam-earthlink.net> wrote:

>One approach in SQL Server is to use DTS. You could create 2 DTS packages
>as follows:
>DTS Package 1:
>1. Import data into temporary tables using DTS Transform Data tasks. DTS
>can import data directly from Excel.
>2. Execute procedures to load various price tables.
>3. Export tables to individual files (containing data only).
>
>DTS Package 2:
>1. Recreate price tables using DDL embedded in DTS package (or simply
>truncate existing destination tables)
>2. Import data into price tables