All About SPs

A recent article from MSDN. here "An Evaluation of Stored Procedures for the .NET Developer" summarizes the pros and cons for using SPs in .NET development.

Start from here: Rob Howard’s blog: pro SP


Con: From Frans Bouma’s blog

  Stored procedures are bad, m’kay?

Converting an Access Database to SQL Server

1.The easiest way to convert an Access database to SQL Server is to use the Upsizing Wizard. The Upsizing Wizard:

  • Preserves database structure, including data, indexes, and default settings.
  • Automatically converts Access validation rules and default settings to the appropriate SQL Server equivalents.
  • Maintains table relationships and referential integrity after you upsize.

To run the Upsizing Wizard in Access 2000/2003, on the Tools menu, point to Database Utilities, and then click Upsizing Wizard.

2. Use SQL Server Data Transformation Services (DTS) to import the data from your Access database to a SQL Server database.