Hi,
I'm going to work on an application that uses a postgreSQL database so
that it can uses SQLServer 2005.
I think I solved most problems on the programming side, but I still
have some doubts on the DB side regarding how to handle the creation
of the db schema on sqlserver and how to handle the every day dba
work.
1) should I try to use an ER tool like Embarcadero and have its
logical model be the master copy ? (i did some tests, it looks like i
have to massage the SQL produced a littel bit to have sqlserver l ike
it).
2) should I handle two separate sql scripts and update both of them
when something change, Additinally I have to produce "the diff"
scripts for upgrades, so that I should keep in sync 4 scripts.
3) Should I try to develop an XML based DDL syntax (like xml2dll) and
a parsing engine, so that I can handle just 2 scripts (create from
scracth and diff).
4) What should I use to move data back & forth ? SSIS (ex dts) or
something else ?
What do you suggest ?
thank you
Best Regards
Enrico Sabbadin
