All About SPs

Posted: December 30, 2004 | Author: | Filed under: SQL Server | Leave a comment

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

Posted: December 28, 2004 | Author: | Filed under: SQL Server | Leave a comment

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