| Author |
Topic |
|
sandlu
Starting Member
17 Posts |
 Posted - 2007-03-13 : 19:27:13
|
| HI,I am trying to find a replication solution. It does not have to be real-time, but snapshot will not work since the database is too big. I was trying to configure Transactional replication. The replication itself worked good, but the Truncate table is not allowed in the transactional replication and merge replication. We have to use "Truncate table" in another processes during replication. Is there any other option or third party application I can use to do the replication with truncate table working. I tried Replication Exec, but it does not support 64bit system, which we have. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-13 : 19:32:14
|
| Do you have to replicate the table that is being truncated? Why do you require truncate table?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sandlu
Starting Member
17 Posts |
Posted - 2007-03-13 : 19:40:56
|
| yes, I have to replicate the tables. This is reporting database, the data will be loaded to the database with the load process, which is a third party application and using the "Truncate table", I could not change it. the data have to be loaded everyday, then replicate to the development database and test database. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-13 : 19:42:43
|
| Why don't you just use BACKUP/RESTORE? How big is the database?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sandlu
Starting Member
17 Posts |
Posted - 2007-03-13 : 19:45:47
|
| It is too big, 500GB |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2007-03-14 : 11:33:09
|
| Just a thought, 1. Disable delete trigger on the table2. Use DELETE instead of truncate------------------------I think, therefore I am - Rene Descartes |
|
|
|
sandlu
Starting Member
17 Posts |
Posted - 2007-03-15 : 11:28:28
|
| Thanks, problem is that I could not use delete instead of Truncate. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2007-03-15 : 11:41:55
|
| May be a dumb question ...but why you are NOT able to use DELETE?------------------------I think, therefore I am - Rene Descartes |
|
|
|
sandlu
Starting Member
17 Posts |
Posted - 2007-03-16 : 17:24:13
|
| A third party applicaiton is using "Truncate" . |
|
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-17 : 01:34:12
|
| Database mirroring is alos an option in this case if you are not mirroing the database...MohammedU |
|
|
|
sandlu
Starting Member
17 Posts |
Posted - 2007-04-06 : 15:31:03
|
| I need to have the access to both primary and secondary databases. I have not mirroring databases, but it seems that only one database is available at any given time point. Am I correct? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-06 : 15:53:44
|
| sandlu, yes that is correct.You should look into database snapshots.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
Replication with Truncate table