O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

A Script for All Database Objects

The form frmSQLDMO_GenerateAllScripts, shown in Figure 23-3, is an extension of the form described earlier. Here the system does not display and save the scripts of individual objects, but instead creates a script for all database objects. This process also includes the database object’s rules (Rules), defaults (Defaults), user-defined data types (UserDefinedDatatypes), and so on.

Figure 23-3. frmSQLDMO_GenerateAllScripts form

The following listing shows the routine the script creates. In the process, the Script method is applied to the respective objects and for every Script command the name of the file ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required