Showing posts with label wich. Show all posts
Showing posts with label wich. Show all posts

Monday, March 12, 2012

Importing DATA wich are in SQL files

Hi
I have to install a lot of data wiich are initialized by an SQL file.
My problem is that the file is too big. My SQL requests exceeds 64Ko and
I cant start theses request in the SQL Editor of MS SQLSERVER 2K :-(
I would like import this file like in MySQL or Oracle, with a command
prompt or any tool.
How can I import this SQL File in SQLSERVER 2000 ?
Thanks in advance for your help.
Alexandre TouretAlexandre,
Did you try using OSQL utility?
AMB
"Alexandre Touret" wrote:

> Hi
> I have to install a lot of data wiich are initialized by an SQL file.
> My problem is that the file is too big. My SQL requests exceeds 64Ko and
> I cant start theses request in the SQL Editor of MS SQLSERVER 2K :-(
> I would like import this file like in MySQL or Oracle, with a command
> prompt or any tool.
> How can I import this SQL File in SQLSERVER 2000 ?
> Thanks in advance for your help.
> Alexandre Touret
>|||Hi
It there are SQL statements in a .SQL file, run them from the command line
by using the command line utility isql.exe
BOL has the syntax information for ISQL.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Alexandre Touret" <atouretNOSPAM@.free.fr> wrote in message
news:423aa143$0$29121$626a14ce@.news.free.fr...
> Hi
> I have to install a lot of data wiich are initialized by an SQL file.
> My problem is that the file is too big. My SQL requests exceeds 64Ko and
> I cant start theses request in the SQL Editor of MS SQLSERVER 2K :-(
> I would like import this file like in MySQL or Oracle, with a command
> prompt or any tool.
> How can I import this SQL File in SQLSERVER 2000 ?
> Thanks in advance for your help.
> Alexandre Touret