Toad World® Forums

How to create Physical model from Logical Model?

I created a logical model for SQL Server to model an inheritance (generalization hierarchy). Now I want to generate a physical model from it. I experimented with the Sync & Convert wizard and read the documentation but still did not see how to do this.

Help please.

Hi,

if you wish to convert Logical model to Physical, open the logical model, click File | Sync & Convert | Sync & Convert Wizard and do the following.

  1. From combo box Select Action choose Convert Model to Another Database System and click Next.
  2. Select your logical model and click Next.
  3. Select your target database (SQL Server 2012) and click Next…
  4. Continue…

Another possibility:
Click File | Sync & Convert | Simple Model Conversion and select target database platform and click Convert.

Regards,

Vaclav