Hi, i want to know if there is a tool like scptxfr in SQL2005, in order to generate a script of all database.
I need this , because i have to make a job that automatically generates script of all database every day for backup.
Thks.
There is no such tool with SQL Server 2005. However you could create such a tool very with SMO with not much effort, depeding on what you want to do:
http://blogs.msdn.com/mwories/articles/smosample_transfer.aspx
No comments:
Post a Comment