Tool for modeling ER diagram and import in SQL server

Question

Is there any tool for ER modeling and then converting models to a Microsoft SQL Server database?

The tool should has this features:

• ER Diagrams shoud be in UML Notation (see this, the last is UML notation).
• Export models to a Microsoft SQL Server 2005/2008 database (by creating a mdf file or connecting to a MSSQL Server and creating suitable database in it).

I tried Microsoft Visio but seems not support UML Notation nor Exporting to MS SQL Server.
I also tried Visual Paradigm but i'm not sure i could export models to MS SQL Server.

Solution

I DID export my ER Model to SQL Server database with DB Visual Architect (a product of from Visual Paradigm family).

DB Visual Architect can export ER model to MSSQLServer/MySQL/...

It also let me to convert a ER Model to a class diagram that is identical to a UML notation.

However, it's not free.

anyway, Thanks all!