Problem executing backup script in Sql Server 2012
-
Hello guys, this is my first message in codeproject. My problem is the next, I have two databases in two different servers of SQL SERVER 2012, both, and I am using indexed views, functions that calling to that indexed views, Full-text catalogs ... I need to have the same structure in both, I do change the database 1 and, I want to have the changes in the second without creating everything from the start. I have tried using scripts and tools like db comparer. I choose the elements or the execution of the script step by step, by order, for avoiding impact problem. Well, I have the following error:
You can not use the CONTAINS or FREETEXT predicate on table or indexed view 'dbo.vwProducts', because it is not full-text indexed.
When I create the script, I select the option of creating "Full-text catalog", but definitely it doesn't create the Full-text catalog correctly. Is there any option of creating a script respecting the data from the database 2 and also incorporating "Full-text catalog" and other changes?
-
Hello guys, this is my first message in codeproject. My problem is the next, I have two databases in two different servers of SQL SERVER 2012, both, and I am using indexed views, functions that calling to that indexed views, Full-text catalogs ... I need to have the same structure in both, I do change the database 1 and, I want to have the changes in the second without creating everything from the start. I have tried using scripts and tools like db comparer. I choose the elements or the execution of the script step by step, by order, for avoiding impact problem. Well, I have the following error:
You can not use the CONTAINS or FREETEXT predicate on table or indexed view 'dbo.vwProducts', because it is not full-text indexed.
When I create the script, I select the option of creating "Full-text catalog", but definitely it doesn't create the Full-text catalog correctly. Is there any option of creating a script respecting the data from the database 2 and also incorporating "Full-text catalog" and other changes?
Caveat - we don't use indexed views or full text so... Have you tried using SQL Compare from Red-Gate, for us, it does an excellent job.
Never underestimate the power of human stupidity RAH
-
Caveat - we don't use indexed views or full text so... Have you tried using SQL Compare from Red-Gate, for us, it does an excellent job.
Never underestimate the power of human stupidity RAH
-
Yes, I have tried with sql compare of redgate and the problem is the same. Any alternative? Anyone has experience doing backups using full text catalog?
delgaillo wrote:
Yes, I have tried with sql compare of redgate and the problem is the same
Now that is interesting, my favourite SQL tool has shortcomings, damn!
Never underestimate the power of human stupidity RAH
-
delgaillo wrote:
Yes, I have tried with sql compare of redgate and the problem is the same
Now that is interesting, my favourite SQL tool has shortcomings, damn!
Never underestimate the power of human stupidity RAH
It is not possible to do a backup of full text catalog, so if you use it, make sure to have the tables and the model finished, or almost finished. Because, if you do changes (to add a column, create a new foreign key...), you will need to create the full text catalog and the indexes over and over again. Despite to everything, I recommend the use of full text catalog in some cases, because his use increase the speed of the querys with filters, it is faster than the use of LIKE in most cases. But the maintenance is bigger.