It is recommended that you update the SQL Server database schema in DDW if there is any change or modification in the database definition on the host.
Select the database in the Schema View for which the schema has to be updated.
On the Schema menu, click Update.
Alternatively, right-click the database and click Update.
The Update Schema dialog box appears.
Note: The name of the database type automatically appears as SQL Server in the Data Manager Type field.
Choose one of the following authentication methods:
Windows Authentication: If the Windows logon credentials are added as a user account in the SQL Server Management Studio, select Windows Authentication.
SQL Server Authentication: If the logon credentials to the selected host is different from the Windows credentials, select SQL Server Authentication. Enter the login credentials in the Login User and Password fields for the selected SQL Server.
Note: Select "Remember Me" to save your credentials for automatic login the next time you update the schema.
(Optional) Click Verify Connection to ensure that a connection can be established with the database.
If the connection is successful, a success notification appears. If the connection fails, an error message appears.
Click OK.
The status bar displays the status once the update is complete.
You can click Cancel to cancel the process.