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?

Advertisements

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.

 

Reference: http://www.sqljunkies.com/Article/BD909D1E-3EA1-4323-889E-5E3A5415B977.scuk