Script Utility

I relied a lot on scptxfr.exe in SQL Server 2000. It does not ship
with the new version of SQL Server and does not work with SQL Server
2005 either. What's the equivalent of that scripting utility in SQL
Server 2005?
Thanks.
Not exactly the equivalent but the Scripting class in SMO
and the Script method is much improved over the Script
method available with SQL Server 2000 DMO. You should be
able to do whatever you were doing with scptxfr using SMO.
-Sue
On 17 Jan 2006 04:43:25 -0800, "baddy" <narsiman@.gmail.com>
wrote:

>I relied a lot on scptxfr.exe in SQL Server 2000. It does not ship
>with the new version of SQL Server and does not work with SQL Server
>2005 either. What's the equivalent of that scripting utility in SQL
>Server 2005?
>Thanks.

script in MSDE

Hi,
i have msde on my system and i running my queries though osql utility
can any one tell me how can i run a script file in osql i.e in my C:
drive
what cmd i have to type
Thanks,Use the /i switch for OSQL.EXE.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Abhi" <bawejaji@.gmail.com> wrote in message
news:1181204598.353419.105710@.k79g2000hse.googlegroups.com...
> Hi,
> i have msde on my system and i running my queries though osql utility
> can any one tell me how can i run a script file in osql i.e in my C:
> drive
> what cmd i have to type
> Thanks,
>|||On Jun 7, 2:59 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> Use the /i switch for OSQL.EXE.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "Abhi" <bawej...@.gmail.com> wrote in message
> news:1181204598.353419.105710@.k79g2000hse.googlegroups.com...
> > Hi,
> > i have msde on my system and i running my queries though osql utility
> > can any one tell me how can i run a script file in osql i.e in my C:
> > drive
> > what cmd i have to type
> > Thanks,
right now I am in osql utility but still i am not able to run the
script i.e on c:\folder
Please advice...|||So you want to call a script while *inside* OSQL? If so, check out the :r option.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Abhi" <bawejaji@.gmail.com> wrote in message
news:1181212829.895541.324540@.n15g2000prd.googlegroups.com...
> On Jun 7, 2:59 pm, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> Use the /i switch for OSQL.EXE.
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>> "Abhi" <bawej...@.gmail.com> wrote in message
>> news:1181204598.353419.105710@.k79g2000hse.googlegroups.com...
>> > Hi,
>> > i have msde on my system and i running my queries though osql utility
>> > can any one tell me how can i run a script file in osql i.e in my C:
>> > drive
>> > what cmd i have to type
>> > Thanks,
> right now I am in osql utility but still i am not able to run the
> script i.e on c:\folder
> Please advice...
>|||On Jun 7, 3:53 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> So you want to call a script while *inside* OSQL? If so, check out the :r option.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "Abhi" <bawej...@.gmail.com> wrote in message
> news:1181212829.895541.324540@.n15g2000prd.googlegroups.com...
> > On Jun 7, 2:59 pm, "Tibor Karaszi"
> > <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> >> Use the /i switch for OSQL.EXE.
> >> --
> >> Tibor Karaszi, SQL Server
> >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/...
> >> "Abhi" <bawej...@.gmail.com> wrote in message
> >>news:1181204598.353419.105710@.k79g2000hse.googlegroups.com...
> >> > Hi,
> >> > i have msde on my system and i running my queries though osql utility
> >> > can any one tell me how can i run a script file in osql i.e in my C:
> >> > drive
> >> > what cmd i have to type
> >> > Thanks,
> > right now I am in osql utility but still i am not able to run the
> > script i.e on c:\folder
> > Please advice...
Many Thanks, Sir it's working in osql

scptxfr.exe

Hello Experts,
I have some Table names and fields in my language (Greek)
and when I use the scptxfr.exe utility to script my DB
then I see "chinese" (Greek argot and maybe yours too). I
try place the Code Page but it didn't worked.
Do you have any suggestions how to resolve this problem?
Is it a good (which scripts hierachical) tool to script
my whole DB?
PS: I got SQL Server 2000 (latest Service Pack)
Thanks in advance.
Konstantinos MichasHi Konstantinos,
Have you tried running the program with the UNICODE
switch ?
That should make it collation independant.
J
>--Original Message--
>Hello Experts,
>I have some Table names and fields in my language (Greek)
>and when I use the scptxfr.exe utility to script my DB
>then I see "chinese" (Greek argot and maybe yours too). I
>try place the Code Page but it didn't worked.
>Do you have any suggestions how to resolve this problem?
>Is it a good (which scripts hierachical) tool to script
>my whole DB?
>PS: I got SQL Server 2000 (latest Service Pack)
>Thanks in advance.
>Konstantinos Michas
>.
>|||Hello Julie and thanks for your reply, it works fine know.
Thanks again!
Konstantinos Michas
>--Original Message--
>Hi Konstantinos,
>Have you tried running the program with the UNICODE
>switch ?
>That should make it collation independant.
>J
>
>>--Original Message--
>>Hello Experts,
>>I have some Table names and fields in my language
(Greek)
>>and when I use the scptxfr.exe utility to script my DB
>>then I see "chinese" (Greek argot and maybe yours too).
I
>>try place the Code Page but it didn't worked.
>>Do you have any suggestions how to resolve this
problem?
>>Is it a good (which scripts hierachical) tool to script
>>my whole DB?
>>PS: I got SQL Server 2000 (latest Service Pack)
>>Thanks in advance.
>>Konstantinos Michas
>>.
>.
>

scptxfr problems on sql 2005

Having used the scptxfr utility successfully on Sql 2000, I am trying to use it against sql 2005. I have had mixed results, in simple databases this seems to work ok however in complex databases the utility appears to hang, has any one had this problem or knows of a workaround?

Scptxfr.exe was a tool included with SQL Server 7.0 and 2000, but not with 2005. One option I've heard people using is located here:

http://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Database%20Publishing%20Wizard

Thanks,
Sam Lester (MSFT)

|||In my experience it worked in SQL 2005 RTM earlier and after that had similar problem.|||

The tool probably works great in some situations with SQL 2005, but is not included with the product and thus not supported. I'd suggest trying some of the other supported tools.

Thanks,
Sam