[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

Scripting Database Objects

I need to script all the objects in all of the databases on our dev server so that we'll have immediate access to our code in case of a failure.  Ultimately the code will be going into a version control database but we're not quite there yet.

Does anyone have any suggestions on the quickest/easiest way to accomplish this?  Thanks.

-Mari
0
Mariyam
Asked:
Mariyam
  • 3
  • 2
1 Solution
 
rafranciscoCommented:
Go to Enterprise Manager, right-click on the database that you want to script, select 'All Tasks', then select Generate SQL Script.
0
 
rafranciscoCommented:
In the General tab, click on Show All and check on Script all objects.  Then go to the Options tab, check on all checkboxes on the Table Scripting Options.
0
 
MariyamAuthor Commented:
Is there any way to do this programmatically?
0
 
rafranciscoCommented:
Sorry to say but I am not aware of any way of doing this programmatically.
0
 
MariyamAuthor Commented:
Okay, thanks.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now