December 11, 2008 at 5:39 am
Hi There,
Can some please help me.
I need to export the database script of the existing DB in SQL2005.
Thanks!!
Vishwajeet:)
December 11, 2008 at 6:03 am
In SSMS and the object explorer right-click on the database select Tasks -> generate scripts and this will walk you through generating the scripts for your database.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 11, 2008 at 6:10 am
:smooooth: Thanks man... Its worked.
March 2, 2010 at 10:30 pm
Hey Guys,
That's all good and well, but what about actually automating this in a job using a script ? Can anybody help me with a scrip that does this ?
Thank you !
March 3, 2010 at 5:57 am
Paul Beetge (3/2/2010)
Hey Guys,That's all good and well, but what about actually automating this in a job using a script ? Can anybody help me with a scrip that does this ?
Thank you !
Just create new job, create as many steps as you want and in one of these steps paste your generated code. Make a schedule to automate it. In other hands you can use Visual studio to create dtsx for your needs.
March 3, 2010 at 6:02 am
Thanx for the reply einoris , but i think you are missing the point im trying to make. I know how a job works, i know how steps work, what i dont know, is what the code is to do this. I cant code. Im just a DBA. Not a DBD. And im new to this. I've been Googling myself to death, and no one can give me a script to script out a SQL 2008 DB. I dont know, i mean there's alot of clever people out there, why doesnt anyone know of any code that can do this ?
March 3, 2010 at 11:12 pm
Hello ? Anybody ?
March 4, 2010 at 5:55 am
Paul,
You might be better off with a new thread.
I don't have a script, but Chad Miller has a blog post about using PowerShell to script indexes using SMO that should provide you with a starting point for getting all object scripts. If you start there and then lookup the SMO library on MSDN you should be able to figure out the rest.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply