have sql file and want to run it on an ftp connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

strawberry - 29 Oct 2005 13:02 GMT

i have a db set up that i access using an ftp connection, and an sql script
file that i wish to run, how do i go about doing so?

tia

Reply to this Message

Erland Sommarskog - 29 Oct 2005 13:25 GMT

> i have a db set up that i access using an ftp connection, and an sql
> script file that i wish to run, how do i go about doing so?

You have an SQL Server database that you access through FTP? Maybe I'm
dense, but I don't understand how you could do that?

Of course, if your FTP client permits you to run remote scripts, you
could upload your script, and then run it with OSQL.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Reply to this Message

strawberry - 29 Oct 2005 23:14 GMT

its hosted on a linux server which has ftp access to it. what is osql?, and
where is the best place to upload it too ?

thanks for your reply

>> i have a db set up that i access using an ftp connection, and an sql
>> script file that i wish to run, how do i go about doing so?
[quoted text clipped - 4 lines]
> Of course, if your FTP client permits you to run remote scripts, you
> could upload your script, and then run it with OSQL.

Reply to this Message

Erland Sommarskog - 29 Oct 2005 23:41 GMT

> its hosted on a linux server which has ftp access to it. what is osql?,
> and where is the best place to upload it too ?

The database is on a Linux server? OK, then you are in the wrong newsgroup.
This newsgroup is about MS SQL Server, which runs only on Windows. (And
OSQL is a command-line tool to access MS SQL Server. On Windows.)

I recommend that you find out which DB engine you are using, and then
find the a forum that engine. Or even better ask the staff at the
university where the DB engine is.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Reply to this Message

strawberry - 30 Oct 2005 08:38 GMT

ahh, oppsy! . hadn't thought of that!

many thanks.

>> its hosted on a linux server which has ftp access to it. what is osql?,
>> and where is the best place to upload it too ?
[quoted text clipped - 7 lines]
> find the a forum that engine. Or even better ask the staff at the
> university where the DB engine is.

Reply to this Message

John Bell - 29 Oct 2005 16:36 GMT

Hi

Why can you not get access to connect to the remote server, possibly through
a VPN?

John

>i have a db set up that i access using an ftp connection, and an sql script
>file that i wish to run, how do i go about doing so?
>
> tia

Reply to this Message

strawberry - 29 Oct 2005 23:13 GMT

this is half the problem, I'm not sure how or where to execute the file I've
tried all sorts but suspect i don't have the correct privileges ( its a
university server)

thanks for your reply.

> Hi
>
[quoted text clipped - 7 lines]
>>
>> tia

Reply to this Message