Tallan's Blog

Tallan’s Experts Share Their Knowledge on Technology, Trends and Solutions to Business Challenges

Posts Tagged "Migration"

Entity Framework 7 Migrations and Source Control

When I first came across migrations in Entity Framework 6 I thought it was a fantastic way to track data model changes in a project.  This thought lasted until my team started to share and sync these migrations through source control.  Anyone that has attempted to use migrations on a development team will agree that it is very cumbersome to sync database changes across development environments.  Searching “on the line” for difficulties in using migrations on a team, you quickly find links to pages such as this, an MSDN article about how hard syncing EF migrations really are.  Most of the issues with EF6 migrations are due to the dependence on the __EFMigrationsHistory table EF6 creates and uses when creating migrations.  Since there was no easy way for devs to share this table, if two devs made changes since the most recent checkin there would…

ScrumDashboard V3 in TFS 2010 with SharePoint 2010

A few of our teams have been using the EMC (formerly Conchango) Scrum for Team System process template for TFS.  We’re doing a migration at a client over to TFS 2010 from TFS 2008, and were attempting to move to the newest version of the process template along with it.
Project Portal Problems
TFS 2010 ships with integration by default for WSS 3.0 for project portals, with the option to use SharePoint 2010, which we decided to go with.  While the process template comes with a WSS3.0 SharePoint .wsp, the developers had offered an updated version of the .wsp for SharePoint 2010, which was basically a retargeted version of the SharePoint 2007 features.  This resulted in project portals with the old SharePoint 2007 look and feel with a ton of visual issues and errors interspersed throughout.
Updated SharePoint 2010 .wsp for Scrum for…

A Look at How to Migrate an Access Database to SQL Server Part 1 of 2

Recently I was tasked with migrating a Microsoft Access 2010 database to SQL Server 2008 R2 while preserving the form functionality built into Access.  While the migration using Microsoft Access’ ‘Upsizing Wizard’ was easy enough for a majority of the objects, I found that a few of the more complex Access queries and tables needed manipulation or outright manual conversion to objects that both SQL Server and Access agreed with.  In this two part blog series I will go through how to use the upsizing wizard to migrate an Access mdb file to an Access Project file connected to a SQL Server backend.  In the second part of this series I will go over some possible roadblocks and issues that could arise, as well as their solutions.
This sample application will have a a simple form opening two parameterized queries, one…