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 |
|
shan1430
Yak Posting Veteran
86 Posts |
 Posted - 2008-03-02 : 21:20:46
|
| Hello,im new for sql. im currently working on a project and i need to deal with sql. i needed a friend's database and she pushed the database using dts into my server. the problem is in my workstation there is two servers one is sphang/sqlexpress and the other one is local server. the database that she pushed is in local since she couldnt push it sphang/sqlexpress. i can copy the database into sphang/sqlexpress but any updates that happens in the local server will not be updated in sphang/sqlexpress right. So how do I get the data from the local server and use it in sphang/sqlexpress? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-02 : 21:31:59
|
| Setup transactional replication between instances, books online tells you how. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-02 : 21:33:58
|
| Is this just a one-time thing? If so, I'd use BACKUP/RESTORE.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
shan1430
Yak Posting Veteran
86 Posts |
Posted - 2008-03-02 : 22:27:50
|
| thanks for the reply. this is not one time update. the data in the table in the database will be updated every 12 hours |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-02 : 22:30:08
|
| Then backup/restore every 12 hours. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-03 : 01:22:23
|
| Why don't you just figure out why she couldn't push to sphang/sqlexpress? What error did she get?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-03 : 01:54:03
|
| When she sets up the DTS jobs - edit to actually push to the Named Instance - this needs to be defined in the packageJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
Copy database