Share via

How to export all DDL statement for entire schema from SQL server using script

C, Manoharan (Cognizant) 40 Reputation points
2025-03-20T08:57:02.2733333+00:00

Hi, I wanted export all DDL script from UAT and importing into my DEV environment for entire schema.

SQL Server | SQL Server Transact-SQL
Accepted answer
  1. Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
    2025-03-20T22:22:23.9166667+00:00

    Right-click the database in Object Explorer, select Tasks from the context menu. In the submenu that opens, select Generate Scripts.

    At some part in the wizard, you come to a window where is an Advanced button. Here you can select what is scripted. Some objects are not scripted by default.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.