Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best way to send table with data
Message
 
À
11/11/2003 12:33:38
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
00848766
Message ID:
00848787
Vues:
10
Sometimes I will need the data because the table is a new picklist, but sometimes there is just a structure change.

For things like this do you write your own scripts, use public domain products, or commercial products?

Thanks,

>>What is considered the best way to send a new table with its data to other developers that are changing the database at the same time as me?
>>
>>Is there a stored proc that inputs a table name and then outputs a script that drops existing if it exists and then recreates possible new structure and then adds data?
>>
>>Please link me.
>>
>>Thanks,
>
>Not sure what you mean by "send...to other developers"....
>but, since v7.0 you can use ALTER TABLE to change structures, bypassing the need to store data/drop/create/restore data.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform