- Open edmx model file
- Go to model browser view
- Expand the Function Imports node
- Double click relevant stored procedure
- Change return type select to Entities and pick desired model
Wow, I've really let this blogging idea slide. I should have been writing more about my coding adventures in the last years. I don't really know where to pickup. I blame it on having 3 kids keeping me busy. As soon as I get home they're begging me to wrestle or play with them. I try to oblige most of the time. But I'm not complaining, I love my kids.
Life is more important than blogging, right?
I have started working with Oracle and I was recently tasked with importing a data pump export to a different schema. Once all the required roles were created and the correct REMAP_SCHEMA option was sorted out* I was left with one interesting problem. Everything remapped properly except triggers. The trigger name was remapped correctly but the target table still referenced the old schema.
Failing sql is: CREATE TRIGGER "NEW_SCHEMA"."TRIGGER_NAME"
BEFORE INSERT ON OLD_SCHEMA.TRIGGER_NAME ...
I'm surprised that something this obvious would go unfixed.
**note Multiple schema remaps are done as follows:
REMAP_SCHEMA=(OLD_SCHEMA1:NEW_SCHEMA1,OLD_SCHEMA2:NEW_SCHEMA2)
alter table tablename change oldname newname varchar (10);
Instead I have to use some sort of SQL Server procedure sp_rename
sp_rename 'TableName.ColumnName', 'NewColumnName', 'COLUMN'
Tags
motorcycle (8) cars (4) work (11) web development (7) porsche (2) life (26) holidays (1) new year (1) photography (3) travel (3) london (1) ubuntu (12) linux (21) birthday (2) weather (1) bow island (2) parenthood (1) qos (1) firewall (1) css (3) fire (1) diy (3) laptop (2) chart (1) test (2) cooling (1) politics (2) harper (1) media (1) modx (1) development (18) pie (1) microsoft (3) sharepoint (1) wine (1) video editor (1) canada (1) abby (1) wii (1) parenting (3) shoelaces (1) christmas (1) pictures (2) unix (1) time (1) google (2) picasa (1) windows (2) joel (1) twitter (1) technology (1) deadline (1) triumph (3) tiger (1) holiday (1) apache (1) mysql (10) tip (1) mechanics (1) server (1) smartphone (1) android (7) vm (1) ted (1) music (1) sql (1) postgres (1) svn (1) vmware (1) house (2) camping (1) replication (2) mechanic (1) oracle (2) databases (1) debian (1) sqlserver (1) sql server (1) datapump (1) blog (1) C# (1) MVC (1)