Now, choose a login mode either Windows Authentication or SQL Server Authentication. If you choose SQL Server Authentication then enter valid user-name and password.
Click on drop down arrow to select the required Database Name.
>
Preview page will be displayed showing only the encrypted object names. Here you can click the object name and preview the script of the object.After that, Click
Next.
Export page will be displayed. Here you select the objects and export them to
SQL server Database or you can export them as
SQL Server Compatible SQL Scripts.
Choose SQL Server option and select the database components you want to export. Then choose the Output mode i.e.
Without Encryption &
With Encryption.
Select target SQL Server name by clicking on the drop-down arrow. and then choose
Login Mode i.e. Windows Authentication or SQL Server Authentication.
Now, choose
Login Mode i.e. Windows Authentication or SQL Server Authentication. If you choose SQL Server Authentication then enter the valid user credentials.
Choose the database name by clicking the drop-down arrow and click
Export button to export the decrypted data.
When the export process is completed an
Export Report will pop up. Click
OK.
Select
SQL Server Compatible SQL Scripts option and choose database components that you want to export.
Choose
Output Mode either
With Encryption or
Without Encryption. And click
Export.
Browse the location to save the resultant file and then click
OK.
An Export report will pop up when the process is completed. Click
OK.
Now, the tool will show the status of the exported data.
