Monday, February 20, 2012

possibile che ...

nessuna sappia dirmi come convertire un database mysql in sql server? Avrei
bisogno di visionare graficamnete le tabelle e le loro relazioni. Qualcuno
pu darmi una mano?
Grazie infinite"ernix" <@. .it> wrote in message
news:Ixhuc.80207$Qc.3217726@.twister1.libero.it...
> nessuna sappia dirmi come convertire un database mysql in sql server?
Avrei
> bisogno di visionare graficamnete le tabelle e le loro relazioni. Qualcuno
> pu darmi una mano?
> Grazie infinite

To convert the database, you can look for an existing tool, or do it
manually. There are lots of database migration tools available (try
searching Google), but unless your database is very simple, you will
probably need to do some manual fixes:

http://www.google.com/search?source...s+sql+migration

If you want to migrate manually, then you could generate scripts for all the
MySQL database objects using whatever tool MySQL provides for this, then try
running the scripts in an empty MSSQL database. I guess there will be lots
of errors, so you would need to correct them, run the scripts again, repeat
etc. until you get a working version.

As for graphical views of the tables and relationships, you can use
Enterprise Manager's database diagrams function to do this for MSSQL
databases.

Simon

No comments:

Post a Comment