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 |
|
kieran5405
Yak Posting Veteran
96 Posts |
 Posted - 2008-08-16 : 10:33:15
|
| Hi,I am using a SQL Server 2005 DB between 2 remote locations. As i make changes to 1 DB I will need to drop the DB in the other location and create the latest 1. However when I look at SQL Server script to create the DB...it doesnt list the rows entered in each table.Is there anyway to get a create script that also includes the data in the DB.Thanks... |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-16 : 10:55:08
|
| Why dropping DB? Can't you use Transactional Replication? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-16 : 18:34:39
|
| Backup db1 and restore it on to db2. |
|
|
|
kieran5405
Yak Posting Veteran
96 Posts |
Posted - 2008-08-20 : 08:55:33
|
| of course...thats the simpliest...ill look into this transactional replication too.thanks... |
|
|
|
|
|
|
Create script that includes DB data