Logins – TL generates DDL for one or all logins. This example generates DDL for all logins on a machine named HARBOR using port 1955:
ddlgen -Uroy -Proy123 -SHARBOR:1955 -TL -N%
The password in the DDL generated
for all logins is “password”.
Alternatively, you can specify an individual login by using -Nusername instead of -N%:
ddlgen -Ulogin -Ppassword -Sserver:port -TL -Nusername
If server-wide password complexity options have been specified for the login or logins, all sp_addlogin and sp_modifylogin DDL statements are generated first, followed by DDL statements for the password complexity options.
This example generates DDL for the login “george” on a machine named HARBOR using port 1955:
ddlgen -Uroy -Proy123 -SHARBOR:1955 -TL -Ngeorge
