What is equivalent command scptxfr.exe in SQL 2005?

microsoft.public.sqlserver.tools

31 Jul 2006 8:28 PM

chatakondu

What is equivalent command scptxfr.exe in SQL 2005?

I have been reading groups that, this is achieved with SMO. If that is
the case can anyone point me to exact location of example. I need to
script the whole database.

Do I have to use .NET only for SMO scripts? If yes what version do I
have to use VS.NET 2003 or VS.NET 2005

Any help is appreciated.

Thanks
Suresh

11 Aug 2006 2:21 PM

Andrew Watt [MVP]

On 31 Jul 2006 13:28:53 -0700, chatako***@gmail.com wrote:

>What is equivalent command scptxfr.exe in SQL 2005?
>
>I have been reading groups that, this is achieved with SMO. If that is
>the case can anyone point me to exact location of example. I need to
>script the whole database.
>
>Do I have to use .NET only for SMO scripts? If yes what version do I
>have to use VS.NET 2003 or VS.NET 2005
>
>Any help is appreciated.
>
>Thanks
>Suresh

You can script a database inside SQL Server Management Studio. Use the
context menu for the node for the relevant database.

To develop using SMO you need .NET Framework 2.0 and Visual Studio
2005.

Andrew Watt MVP