Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
!INC Local Scripts.EAConstants-JavaScript
function GetEAVersionInfo() {
var edition = Repository.GetEAEdition(); // e.g., "Corporate Edition"
var version = Repository.LibraryVersion; // e.g., "1713"
Session.Output("EA Edition: " + edition);
Session.Output("EA Version and Build: " + version);
}
GetEAVersionInfo();```They all should have EAUML::tableWhich indicates the fix would be to run a script and set all the stereotypes to EAUML::table.
Geert
| . • Pros: Easy to query remote data directly. • Cons: Performance can degrade with large datasets; security considerations. ________________________________________ 4. Import/Export Wizard (SSMS) • Use case: One-time or simple transfers. • How: Use SSMS's wizard to copy tables, views, or queries between servers. • Pros: GUI-based, quick setup. • Cons: Limited control over complex logic or transformations. ________________________________________ 5. Replication (Transactional, Merge, Snapshot) • Use case: Real-time or near-real-time data synchronization. • How: Set up replication between servers. • Pros: Automated, supports continuous sync. • Cons: Complex setup, requires careful planning. ________________________________________ 6. Change Data Capture (CDC) or Change Tracking • Use case: Incremental data movement. • How: Track changes in source DB and apply them to target. • Pros: Efficient for syncing deltas. • Cons: Requires additional logic or tooling to move changes. ________________________________________ 7. BCP (Bulk Copy Program) • Use case: Fast bulk data export/import. • How: Use bcp command-line tool to export data to a file and import it into the target server. • Pros: Very fast for large datasets. • Cons: Schema must be managed separately; not ideal for complex types. ________________________________________ 8. Azure Data Factory / Synapse Pipelines • Use case: Cloud-based or hybrid environments. • How: Use ADF pipelines to move data between on-prem and cloud SQL Servers. • Pros: Scalable, supports many sources/destinations. • Cons: Requires Azure setup. Here are strategies to manage this securely: ________________________________________ 1. Use a Dedicated Transfer Account with Least Privilege • Create a SQL Server login or Windows-authenticated account that has: • Read-only access to the source DB. • Write-only access to the target DB. • This avoids privilege escalation and ensures the account can only perform the transfer task. ________________________________________ 2. Avoid Transferring Security Principals Directly • Do not transfer logins, roles, or permissions unless explicitly required. • Instead, map users and roles manually on the target DB to match your security model. ________________________________________ 3. Use SSIS with Impersonation or Proxy Accounts • SSIS allows you to run packages under a proxy account or use impersonation to access source/target with different credentials. • You can configure connection managers with separate credentials for each DB. ________________________________________ 4. Script Data Transfer Without Security Metadata • Use INSERT INTO ... SELECT FROM ... or BCP/Import-Export tools to move only data, not users, roles, or permissions. • This ensures the target DB enforces its own security model. ________________________________________ 5. Use Contained Databases (if applicable) • If using contained databases, users are defined within the DB itself. • You can script user creation separately on the target DB without relying on server-level logins. ________________________________________ 6. Audit and Validate Post-Transfer • After transfer, validate: • Row-level security (if used). • Permissions on tables, views, and stored procedures. • That no sensitive data was exposed to unauthorized users. ________________________________________ 7. Encrypt Sensitive Data During Transfer • Use Transparent Data Encryption (TDE) or Always Encrypted if transferring sensitive data. • For SSIS or BCP, consider encrypting files in transit and at rest. As mentioned Sparx EA has project transfer built in but its slower and it will transfer the source security settings for Sparx EA so that may not be an option. |
shape main
{
layouttype="border";
image("EAI::FileTransfer",0,0,100,100);
addsubshape("name","S");
shape name
{
h_align="center";
print("#NAME#");
}
}
// Work Package
shape main
{
layouttype="border";
noshadow=true;
if(hasproperty("diagram.stereotype","Sunray"))
{
defsize(20,20);
startpath();
setfillcolor(getuserbordercolor());
ellipse(0,0,100,100);
endpath();
fillandstrokepath();
}
else
{
defsize(90,70);
startpath();
roundrect(0,0,100,100,20,20);
endpath();
fillandstrokepath();
addsubshape("padding","n");
addsubshape("name","center");
}
shape padding
{
preferredheight=20;
}
shape name
{
h_align="center";
v_align="top";
print("#name#");
}
}
shape label
{
setorigin("n",0,0);
if(hasproperty("diagram.stereotype","Sunray"))
{
setorigin("w",0,0);
// print("#alias# - #name#");
print("#name#");
}
}
