Skip to content
Advertisement

Tag: database-administration

Strange variables MySQL [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations. Closed 11 months ago. Improve this question Can someone tell me what “skip_name_resolve” and “skip_grant_tables” MySQL variables do

Replace Database WIth Copy Of Other Database

As part of our testing process, I’m trying to automate the following: Drop DatabaseB. Create a backup of DatabaseA Recreate DatabaseB from the backup of DatabaseA I had hoped something like this would work RESTORE DATABASE DatabaseB FROM DISK = ‘c:tempDatabaseA.bak’ WITH REPLACE, but that turns out to want to overwrite the existing ldf and mdf files for DatabaseA. It

Enabling CDC in SQL Server 2005 won’t work?

I am trying to use AWS replicate following this tutorial – https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.CDC.Publication . Using this code on a 2005 Microsoft SQL table Results in Could not find stored procedure ‘msdb.dbo.rds_cdc_enable_db’. This is the driver currently MS SQL Server / SQL Server (Old driver, jTDS) Any idea on how to overcome this issue? Answer CDC is not available in SQLServer 2005.

Advertisement