No table data yet...
No table data yet...
Job Status: Loading...
Schedule: Daily at 03:00 AM
Last Run: Never
Next Scheduled Run: Not scheduled
This job automatically syncs the production database to the test3 environment daily.
No active downloads
No files available
Your session will expire in 60 seconds due to inactivity.
Click "Continue" to extend your session, or you will be automatically logged out.
Environment:
Provide admin credentials and we'll create the logins for you.
Copy and run this script in SQL Server Management Studio:
-- Run on TARGET server (master database)
USE master;
GO
-- BacpacExportLogin (REQUIRED)
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = 'BacpacExportLogin')
CREATE LOGIN [BacpacExportLogin]
WITH PASSWORD = '3zuTcssn1dpK0T!NDc@64%tKAYATTEOO8qw1yfPfQuT';
GO
-- dis_dev4 (Development user)
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = 'dis_dev4')
CREATE LOGIN [dis_dev4] WITH PASSWORD = 'ChangeThis123!';
GO
-- vlad (Power user)
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = 'vlad')
CREATE LOGIN [vlad] WITH PASSWORD = 'ChangeThis123!';
GO
File: