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 |
|
anitamel
Starting Member
2 Posts |
 Posted - 2006-09-08 : 13:09:24
|
| I need to export tables/views/stored procs and user functions from one DB to another on a regular schedule. It would be good if I can make a deployable application so that it can be scheduled with sql agent.I tried to use DTSWizard with Management studio but it does not seem to export stored procedures. Can someone walk me though this ?Is there somewhere I can read which scenarios its is best to usebcp, import/export, replication, backup/restore ?Thankyou |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-09-08 : 17:12:48
|
| The easiest thing to do is set up a DTS package, use a Copy SQL Object task. That said I've run into some issues using that task in SSIS.I'd suggest reading up on those topics in BOL. |
 |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-09 : 07:34:56
|
| You can use the SQLDMO library to do this. Write a small wrapper app to extract the relevant scripts and run them on the other database. Check out SQLDMO in books online. |
|
|
|
|
|
|
Import/Export for stored procs