RE: FN-FORUM: Sql server - sql file batch

date posted 14th July 2005 15:41

[EMAIL REMOVED] wrote:
> Can I run a whole host of files containing sql commands from the
> command line as I would like to run these on the server - I have
> about 5600 users to transfer from one database to another and doing
> it from my machine here over the internet is taking about 1hr45mins
> to move 200 across and the connection keeps dropping etc and screwing
> me over (the time is because of a load of transformations etc that
> need to occur).
>
> Can I use the command line as I am sure I can use isql (has been a
> while)
>
> Best Regards
>
> John

Yep, isql can be used to run any sql commands you like from command line or
a batch file afaik. Certainly always worked when I have used it.

--
TechnologyAngel
http://www.technologyangel.co.uk/