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 |
|
vchandm23
Starting Member
5 Posts |
 Posted - 2012-07-24 : 01:34:24
|
| Hi all, Here's the scenario. We tried to create a full text indexing on a view, unfortunately the view was created based on Left outer join. Hence we were pushed to do the following.We planned to create a table based on the data that is rendered in this view(this view is formed by combining 14 tables.) . Finally we were able to create a full text indexing on this new table. For simplicity let us called this new table as tableA. Now the problem is how can we update (if any data is changed on one of the concrete tables of the view) or insert (when new data is inserted in one of the underlying tables of the view) the respective data into this new table - tableA which was created based on this view.In other words, there should be a sync between the view and tableA. Is it possible to achieve this ??? PS : view is formed based on different tables (not based on tableA)? Cheers,Chandra. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-07-24 : 03:51:48
|
| I suppose you could put a trigger on the view. I generally do not like triggers, but this does seem the perfect scenario for one. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-24 : 09:58:05
|
| how frequently you want syncing to happen? is it a OLTP or OLAP system?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
vchandm23
Starting Member
5 Posts |
Posted - 2012-07-24 : 19:39:24
|
| The sync should happen whenever that data in the base tables are updated. The data in the view will change accordingly. Whenever the view data changes, then the new data or updated data from the view must be moved to the new table. Only 1 row of data will be updated in 1 week or 15 datas in a month. Cheers,Chandra. |
|
|
|
vchandm23
Starting Member
5 Posts |
Posted - 2012-07-24 : 21:54:10
|
| @RickD : Thank you mate. I have finally derived the solution for it. thanks for your help and suggestions .Cheers,Chandra. |
|
|
|
|
|
|
Is this possible to do with the views?