Import schema into SqlExpress

[lbolognini@gmail.com]

Hi all,

I've got a PostgreSQL schema, how can I import it in SqlExpress?

What's the best tool for administering Sql Express.

Thanks,
Lorenzo

[John Bell]

Re: Import schema into SqlExpress

Hi

I am not a Postgres expert, but if there is a way to generate the DDL
(CREATE TABLE scripts) you could use that and modify any syntax that is not
SQLExpress compliant. Alternatively you may be able to reverse engineer the
database with a CASE/design tool such as Visio/Erwin/ER_studio etc... and
use that.

For specific questions on SQL Express you should ask in the express
newsgroup

http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us&NewsGroup=microsoft.private.sqlserver2005.express

John

<lbolognini@gma il.com> wrote in message
news:1117710946 .423920.164950@ g44g2000cwa.goo glegroups.com.. .[color=blue]
> Hi all,
>
> I've got a PostgreSQL schema, how can I import it in SqlExpress?
>
> What's the best tool for administering Sql Express.
>
> Thanks,
> Lorenzo
>[/color]

[lbolognini@gmail.com]

Re: Import schema into SqlExpress

John Bell wrote:[color=blue]
> Hi
>
> I am not a Postgres expert, but if there is a way to generate the DDL[/color]

Hi John,

yeah I got that. found out there are some command line tools that
should do the job just fine, then I could mantain it allright from
Visual Web Developer
[color=blue]
> For specific questions on SQL Express you should ask in the express
> newsgroup[/color]

Thanks, didn't know about that, I'll post there from now on

Lorenzo