Mass Ingestion
- Mass Ingestion
- 所有产品
USE master; CREATE DATABASE <database>; CREATE LOGIN <login_name> WITH PASSWORD = '<password>'; CREATE USER <user> FOR LOGIN <login_name>; GRANT SELECT ON master.sys.fn_dblog TO <user>; GRANT VIEW SERVER STATE TO <login_name>; GRANT VIEW ANY DEFINITION TO <login_name>; USE <db>; CREATE USER <user> FOR LOGIN <login_name>; EXEC sp_addrolemember 'db_owner', '<user>'; EXEC sys.sp_cdc_enable_db
USE master; CREATE DATABASE <database>; CREATE LOGIN <login> WITH PASSWORD = '<password>'; USE <database>; EXEC msdb.dbo.rds_cdc_enable_db '<database>'; CREATE USER <user> FOR LOGIN <login_name>; USE master; GRANT VIEW SERVER STATE TO <login_name >; GRANT VIEW ANY DEFINITION TO <login_name >; USE <database>; EXEC sp_addrolemember 'db_owner', '<user>';
SELECT <column_name>, CONVERT(varbinary,<column_name>) from <table_name>;