Tuesday, February 16, 2016

Migration SQL Server 2008R2-SQL Server 2014(incomplete)



Deprecated features: find what features are deprecated?

https://www.mssqltips.com/sqlservertip/1370/identifying-deprecated-sql-server-code-with-profiler/
https://www.mssqltips.com/sqlservertip/1857/identify-deprecated-sql-server-code-with-extended-events/


when database backup and restored to any machine server, users will be moved , all we need to move is logins

when database is read only, backed up,
restore will also have same read only 

No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...