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 |
|
sdp
Starting Member
12 Posts |
 Posted - 2008-02-14 : 06:27:05
|
| Hi guys,I am looking for a way to export the TABLES only from my database to another database on a nightly basis (we already have scripts that backup the entire db).The 'Import/Export' wizard in Management Studio works great but there's no automate/schedule option.Thanks for your help |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-14 : 06:34:47
|
| In the last screen of Import Export wizard, you have an option to save the package to SQL Server. Once you do that, you can schedule the package as per your requirements.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-14 : 06:34:59
|
| You can add a DTS package which does this(you can even create this from import/export wizard). then add a sql server agent job which calls this DTS package and schedule it accordingly. |
|
|
|
sdp
Starting Member
12 Posts |
Posted - 2008-02-14 : 06:49:26
|
| Thanks guys.Out of interest it seems to store a list of tables to copy - if I add new tables to the database I take it this script won't export them. Any way to always export all tables? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 00:05:14
|
| Create ssis package for this and run the package as sql job. |
|
|
|
|
|
|
Scheduling data export (tables only)