Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to send table with data
Message
 
To
11/11/2003 12:33:38
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00848766
Message ID:
00848787
Views:
9
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform