Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
johnsql
Posting Yak Master
161 Posts |
 Posted - 2006-09-06 : 16:25:44
|
| Hi, I have 2 databases, one called X (development db) and the other is Y (production db). I work with db X (development db), and I alter table A, create a new table B, create a new stored procedure C. After I am done my works with db X, now in db Y, I want to do the same things as I do in db X (assume I already have old version table A in db Y but not table B, new sp C, so can you tell me what is the fastest and most convenient way to make same changes/ new creating for db Y?Any idea? Thanks in advance. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-09-06 : 20:48:27
|
| Generate Scripts for that table and sp from developement db and run them in Production db MadhivananFailing to plan is Planning to fail |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-09-06 : 20:52:19
|
| You could also use a too like Red Gate's SQL Compare to do the work for you on this. I've bene using it for years and love it. No, I do not work for them or get any kickbacks, but they do advertise at this site.http://www.red-gate.comMichael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-09-07 : 13:08:47
|
| You could create a DTS with a Copy SQL Server Objects task. |
|
|
|
|
|
|
|
|
copy/create tables, sp, functions from a db to db