Today I found a great post about migrating from MS Access to MS SQL Server 2005.
The tool used is called “SQL Server Migration Assistant for Access”. According to the description it “Automates database migration from Access to SQL Server 2005″.
If you want to migrate to MS SQL Server 2000 you can read my previous post […]
Archive for the 'SQL' Category
Problem
From the practice lessons I’ve learned I came to the conclusion that Access databases can be used for simple CMS (Content Management Systems).
In most cases Access is not appropriate for creating complicated business logic. The case that I’m writing is about migrating an Access database to MS SQL Server 2000. The main goal was to […]
Below I’ll describe a problem with views that is raised when view related tables are changed.
Problem: When structure of a table is changed, all views that use “SELECT *” from this table must be refreshed manually. Otherwise the changes do not affect the views. Below are the steps to reproduce this behavior:
Create a […]
Recent Comments