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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-25 : 08:15:46
|
| Frank writes "How can I automate the process of migrating lookup data and objects from dev/staging to production?Is this doable? if so how? cn this also bypasses firewalls.I am new to sql dba tasks b/c I was involved in development so far in asp/vb.net.thanks." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-09-25 : 11:23:40
|
| Read up on Replication.Jay White{0} |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-25 : 12:08:59
|
| This isn't automated and nor should it be...What I do for lookup data is either bcp the data out of the tables into files or I run sp_generate_inserts to generate the INSERT statements for me. sp_generate_inserts can be found at vyaskn.tripon.com.I would not use replication for lookup data since you might not want the data transferred to the destination server for quite some time.Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-25 : 13:38:23
|
| You should have a system test and release test system. These should be updated by scripts created by the developers and the same scripts used for the migration to production.See http://www.nigelrivett.net/SQLServerReleaseControl.htm==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
importing data and objects from dev to prod servers?