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.

SCPTXFR.EXE-- Problem with Drop procedure

hi there
I am using SCPTXFR.EXE to generate script of the database(for backup),using following command.

SCPTXFR.EXE /s abc /d aaa /P abc12345 /f D:\HSE0607\SCHEMA.sql /q/r/T

Now the script is generating fine, but what i find that there is no statment like
"if not exists(...) "
for the Stored Procedure( i had applied the /r parameter), for the Create Tables it is there.

Why there is no statment IF NOT EXISTS(...) for Stored Procedure?
I need this Line, how can i do this?
Regards,
Thanks.
Gurpreet S. Gill

hey nobody help me here, but i find the solution at

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73290

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