running sql file with java on a remote machine

Question

i have an sql file of the following form:

CREATE VIEW dbo.SomeView
AS select * from SomeTable
GO

ALTER TABLE [SomeTable] ADD CONSTRAINT [...] PRIMARY KEY CLUSTERED ([..],[TIME_STAMP],[..])
GO

and so on.. it contains only update queries.
i want to run it on an sql server that is situated on a remote machine. I'm using java and i read it is not possible to execute a file through jdbc.
i read this related post:
How to execute sql-script file in java?

my question is, how can i execute that file if the server is on a remote machine and not on my machine (i don't have mssql server installed on my machine)?

P.S it would be nice to know if there is a solution to this problem in other languages (just a reference will do)

EDIT: the file is on the local machine.

thank ppl!

You have the sql file on your local machine and the sql server is remote or does is the server and the file on the same machine? — Eggi
– Eggi, Commented Mar 8, 2012 at 9:40
This answer to the linked question is best stackoverflow.com/a/2071724/116509. JDBC can run the individual queries remotely once you split up the file. — artbristol
– artbristol, Commented Mar 8, 2012 at 11:13

rlegendi · Accepted Answer · 2012-03-08 11:15:42Z

1

Do you have developer access to the remote machine? I.e., can you open ports? You can use a simple socket and a remote shell to execute the queries (both sides can be Java but anything else will do).

If you have no administrative privileges, you might use some SSH API to login and execute a script.

If you have installed the SQL tools on your machine, you can still run them on the remote (if it is enabled and there are no firewall restrictions, for instance, but some additional configuration might be necessary). With MySQL, you may use something like this:

 mysql -u dbuser –h remote.host.name –p < script.sql

You can even do this from Java with the script you linked.

answered Mar 8, 2012 at 11:15

rlegendi

10.7k4 gold badges43 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

running sql file with java on a remote machine

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related