Monday, March 19, 2012

.sql file

hi,
i have a sql file that is exported from the other sql server.
how to import this sql file into my new sql server?
the sql file contains the structure/description of the procedures.
thank you.Blue
Run
EXEC master..xp_cmdshell 'osql.exe -S SERVER -U sa -P pass -dNorthwind -i
"D:\ORD1.sql"'
Let me say you have ORD1.sql file which constains
CREATE PROC spMyProc
AS
SELECT * FROM Orders
<Blue> wrote in message news:%23jxZ549kEHA.3372@.TK2MSFTNGP09.phx.gbl...
> hi,
> i have a sql file that is exported from the other sql server.
> how to import this sql file into my new sql server?
> the sql file contains the structure/description of the procedures.
> thank you.
>

No comments:

Post a Comment