RSS

Category Archives: MSSQL

Most Useful websites for developers


Email Marketing – http://mailchimp.com/

Time Tracking system – https://www.toggl.com/

Web Designing and hosting – http://www.webs.com/ , http://www.ucoz.com/

Issue Tracking system  –  https://www.etraxis.com/

 

 
2 Comments

Posted by on September 18, 2012 in java, MSSQL, mysql, Other

 

Tags: , , , ,

How to Create Sample Database in MSSQL with Sample Data


This is very useful for application testing.

First you have to download the relevant sample databases from http://msftdbprodsamples.codeplex.com/releases/view/59211

Then copy the relevant AdventureWorks2008R2_Data.mdf file in to your machine where the MSSQL is installed. then go to MSSQL Editor and run the following query


CREATE DATABASE AdventureWorks2012
ON (FILENAME = 'D:\AdventureWorks2012_Data.mdf')
FOR ATTACH_REBUILD_LOG ;

Don’t delete the above AdventureWorks2008R2_Data.mdf because this will be your database in MSSQL

 
Leave a comment

Posted by on September 14, 2012 in MSSQL

 

Tags: , , ,

 
%d bloggers like this: