Generate SQL Script

Question

Generate SQL Script

Mathew Abraham

SSC Journeyman

Points: 86
More actions
May 13, 2005 at 6:10 am

#66275

How Can I Generate Sql Script with out using Enterprise Manager preferably using T-SQL

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Farrell Keough SSCoach Points: 17414 More actions · Answer 1

I think you may want to be more specific in your question. Query Analyzer is basically a notepad interface in which you make your own code to run. There are ways to write such that it will generate output that is a script; for instance you can run code to query one table which will generate output that can be used to populate another table.

Maybe give us an idea of what you want to achieve?

I wasn't born stupid - I had to study.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

I don't know of a way with pure T-SQL. The object browser in QA will do something similar to Enterprise Manager and I think SQL-DMO also has a script() method.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

bersileus sacamay-126226 SSChasing Mays Points: 642 More actions · Answer 3

c:\program files\microsoft sql server\mssql\upgrade\scptxfr.exe /s <servername> /P <password> /d northwind /f northwind.sql