Hosted by Chris Testa-O'Neill

Speaker - Andrew Couch

Andrew Couch is an Access MVP and originator of the MUST product series (www.upsizing.co.uk) which is now used by over 70 international companies when converting Access Databases to SQL Server and .net. Andrew has over 15 years experience converting databases and is also a founder member of the UK Access User Group.

Agenda

18:00 - 18:30 - Introduction, Networking and Food

18:30 - 19:00 – Round Table problems and answers, SQL nuggets - bring a tip or 1 - 5 minute demo and share with your peers.

19:00 - 19:45 – Converting Access Databases to SQL Server - Andrew Couch

In this talk we will look at how to resolve issues relating to structural differences, data content and data types in databases designed using Microsoft Access that need to be converted to SQL Server. We will then dig deep into design techniques used by Access Developers when writing SQL, and see how to convert Queries from Access to SQL Server views and stored procedures, looking both at syntactical dialect differences in the SQL, and how to map Access Developer techniques to equivalent methods in SQL Server. Other issues which will be discussed include using Database Roles, Schemas and Synonyms to assist in migrating a design.

19:45 - 20:00 – Break

20:00 - 21:00 - SQLDataSources, LINQDataSources and EntityDatasources in Database Design - Andrew Couch

In this talk we will contrast and compare developing WebForm applications using Visual Studio 2008 with different types of datasources. We will be looking at design issues relating to concurrency control and updateability when using key Visual Studio controls such as the FormView and ListView controls. So if you don’t know where to start in choosing between SQL, LINQ and Entity datasources then you will by the end of this talk. We will also take a look at techniques for the seamless integration of ASP.net security with SQL Server Login security for web applications using LINQ.