February 3, 2007 at 12:47 am
We have a large database (datawarehouse) that we don't back up (the source data comes from another server so we are not overly concerned with the warehouse.) But the logins, tables, indexes, etc. used in the database ("Schema') are important to us. I have used the sql 2005 Generate Scripts option (Tasks > Generate Scripts) manually to script all items in a database. That's what we want. Is there any way to automate this script generation and run it on a nightly basis?
TIA,
Bill
February 3, 2007 at 7:39 am
I am not confident but hope that it can be done using DTS tasks. I shall try and let u know the steps to be followed for that.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 4, 2007 at 3:57 pm
copy the file scptxfr.exe file from C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade folder and use this utility to script the objects and it works with sql 2005.
also to script logins you can use the script from the following...
http://support.microsoft.com/kb/246133
MohammedU
Microsoft SQL Server MVP
February 4, 2007 at 6:52 pm
I did a fresh install of sql 2005 and apparently don't have the Upgrade folder you referred to in your posting.
Bill
February 4, 2007 at 10:12 pm
My bad I forgot to mention that... you will find this utility in SQL 2000 UPGRADE folder but works with 2005...
If you have any 2000 server check the UPGRADE folder...I beleive you can copy it...
MohammedU
Microsoft SQL Server MVP
March 10, 2007 at 8:20 am
You might want to check out this free tool. It's a cmd line app so it would be easy to schedule it to run nightly. Also the source is available so if it doesn't meet your needs you can tweak it.
http://www.elsasoft.org/tools.htm
---------------------------------------
elsasoft.org
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply