Supported Databases
Microsoft SQL Server
Extract SQL Server schema metadata and generate T-SQL using the SQL Server database profile.
Steps
1
Choose SQL Server
Select Microsoft SQL Server before generating the metadata script.
2
Enter schema-qualified tables
Use names such as dbo.Customers where schemas need to be explicit.
3
Run the script in your SQL Server tool
Review and execute the generated catalogue query using approved access.
4
Review T-SQL output
Check identifier quoting, functions, dates, and version-specific syntax before running generated SQL.
Open the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.