SQL Server Database Creation Script in SQL 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server Database Creation Script in SQL 2005

In SQL Server 2000 we are created a job(daily) to generate the database schema using the utility scptxfr.exe . It looks this utility is no longer with 2005. How can i generate the schema in 2005? Your inputs would be help me a lot… Thanks,
Mahi
http://support.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.tools&tid=b97d60f3-cf84-4512-ab3a-40536af17b35&p=1 seems to be no.
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. —————————————-
Yes that .exe is deprecated in SQL 2005 and follow as suggested above.
http://www.sqlteam.com/publish/scriptio/ fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
I Think it need to be done manually Using the context menu for the node for the relevant database.
How can i make it automated, i want to generate the script in daily basis. Please suggest me the way. Thanks,
Mahi
Hello Satya, Can you please help me in this… How can I automate creating the database script. Thanks,
Mahi
Read about Jobs in sql server help file Madhivanan Failing to plan is Planning to fail
]]>