Azure Sql - Cross Database Trigger
I am migrating my database from sql server to Sql Azure. I have two databases in place which talk to each other using trigger. i.e If any record is inserted in Customer table of first database the trigger gets fired and record is inserted in another database.
I came to know that Sql Azure does not support such kind of cross database queries. Though by researching more i found a new feature called Elastic Query . Can any one tell me how to write Trigger that works between two database in Sql Azure ?
Answer
Don't.
Move the dependency in the application and have the application update both databases, as appropriate.
Doing what you're trying to do was a bad practice on-premise as well (think backups-restore and availability issue scenarios), but you could get away with it. Lucklily the Azure restrictions will force you to devise a better solution.
Related Questions
- → How to make Laravel use my class instead of native PDO?
- → SQL: simple custom column in select doesn't work?
- → How to execute Stored Procedure from Laravel
- → Which database engine type should be specified for Microsoft SQL Database in Laravel?
- → How to troubleshoot PDOException?
- → laravel sql server stored procedure output
- → Issue with converting a date using Carbon
- → SQL microsoft query to Laravel 4.2
- → General error 20018 Cannot Continue the file execution because the session is in the Kill state
- → List names of all available MS SQL databases on server using python
- → Variable which replace DB of name in SSMS
- → Java: database connection. Where is my mistake?
- → How Can I use "Date" Datatype in sql server?