Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Properties option doesn't show in SSMS for Azure DB

I am trying to create a full-text search mechanism, to do that I created full text catalog in my local database. Then I opened context menu and it had properties option. local db

I opened it and set up tables/views tracking. But when I tried to do the same with remote Azure database, I could not open properties window. remote db

Any idea how can I open/edit settings I need?

like image 753
IAmVisco Avatar asked Oct 15 '25 14:10

IAmVisco


1 Answers

I was playing around with SSMS and found an interesting solution to this. As Alberto Morillo mentioned, to do operations with Azure SQL DB you need to use Transact-SQL. I never worked with it and basic SQL knowledge turned out to be not enough. But I found interesting option in SSMS. I went to my local DB, created new catalog, set everything like I need and instead of saving, I pressed 'Save script to file'. This generated Transact-SQL code that I needed, all I did after is changed names and executed that queries on my Azure DB.

like image 200
IAmVisco Avatar answered Oct 18 '25 05:10

IAmVisco



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!