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 |
|
kesm0724
Starting Member
2 Posts |
 Posted - 2008-02-24 : 17:01:10
|
| Scenario:Application uses historical data for alarms, responses, etc. The application came with a sync agent but the agent only syncronizes at a minimum every 15 minutes (nice HA feature we paid for). 15 Minues is unacceptable in the event it syncronizes then 5 minutes later the database goes down - we lose 10 minutes of data. I have configured a standby server and have configured snapshot replication since the application also uses simple recovery mode, has tables with no PK, etc - so transactional / merge replication are out of the picture.I have created publisher / subscriber configurations and all is fine....the problem comes into play with historical data. All data is stored in a database say 'History0208' indicating the current month/year. Each month a new database is created (I am assuming at 12:00 am of the first day of each month) but I will need to replicate the new database over to the subcriber. How can I go about automating this? There is a table called 'History Data' which does indicate the datapath 'History0208' for the current month. Could I call this value from the table into a stored procedure? How would i go about doing this....thanks for any help. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-24 : 18:04:19
|
| In SQL Server 2005 , all DDL changes will be replicated as well. |
 |
|
|
kesm0724
Starting Member
2 Posts |
Posted - 2008-02-24 : 18:15:33
|
| Yes, but won't I still need to create a publication and a subscription since say there isn't currently a History0308 database until March 1st, 2008 at 12:00 am? Is there a way to automatically have a publication and subscription made for any new database when it's created whether by the system or manually? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-25 : 15:02:14
|
| No, have to set it after creating db. |
|
|
|
|
|
|
How to replicate databases created by application