Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Compare SQL database scripts?
Message
De
20/10/2009 15:53:19
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01430142
Message ID:
01430183
Vues:
53
>I think Beyond Compare might work. What I've just now discovered is that the two databases are in different versions of SQL and the scripts I received show different options. I don't know if this is due to version or the options the DBAs selected. The create table statements don't even appear in the same order. Once I cull through all of that, it might be just as easy to do it manually :-(

May be faster to run both scripts, i.e. create the other database on one of the servers, and then generate scripts from the same server, with the same options. That should produce comparable scripts.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform