Backup SQL Schema Only? Backup SQL Schema Only? oracle oracle

Backup SQL Schema Only?


Use a 3 step process:

  1. Generate a script from the working database
  2. Create a new database from that script
  3. Create a backup of the new database


Why not just use SQL Management Studio to create a complete script of your database and the objects?


Toad for SQL Server does this nicely, if you're considering a commercial product.