How to use northwind SQL file without having MsSQL in my system.

Posted by Thiru under Regular Expressions on 3/3/2011 | Points: 10 | Views : 1787 | Status : [Member] | Replies : 8
While downloading ASP.NET sample source code from public websites - its normally contains
northwind SQL file along with source code. Hope it means they used MsSql as backend.

For our information: I am using mysql db as backend for all my project, dont even install MsSQL in my laptop.

so, is there any way to run that sample source code along with northwind SQL file (downloaded from public websites)
without installing MsSQL in my laptop ?

or if it 100% required to install MsSQL -- please let me know, Is there any free MsSQL installation file available .

Expecting your valuable reply in this regard.

Thanks & Regards,
Thiru




Responses

Posted by: Karthikanbarasan on: 3/3/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
Hi,

I hope you need to have the server to be used by the application...

Thanks
Karthik
www.f5Debug.net

Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Madhu.b.rokkam on: 3/3/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
As per my understanding we need to have SQL Server installed in machine to use that,
You can install the Free SQL Express editions available in the MSDN site...
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41

Thanks and Regards
Madhu

Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Thiru on: 3/4/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Madhu,
Thanks for your link - i just downloaded and installed in my Lap.
please let me know how to view the data in the MSSQL database file ?

Is there any tool to browse the data of *.MDF file ?

Note: There are two files:
1. SQL Server Database Primary Data File
2. SQL Server Database Transaction Log File

expecting your valuable reply.
Thanks & Regards,
Thiru

Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Madhu.b.rokkam on: 3/4/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
You need to attach your DB's into sql server. For that open SQl server and rightclick on database click on attach and specify your db files and after that you can check all your related db objects from there ...

Thanks and Regards
Madhu

Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Thiru on: 3/4/2011 [Member] Starter | Points: 25

Up
0
Down
Thanks for your reply.
But its confusing me.
In mysql db - i used SQLyog software to browse the data.

But in MsSQL -- i can able to see the following files in my Start menu:
C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft SQL Server 2005\Configuration Tools
under this 3 files are there:
SQL Server Configuration Manager
SQL Server Error and Usage Reporting
SQL Server Surface Area Configuration



Please tell me how to open the db file ?

Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Madhu.b.rokkam on: 3/4/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Open SQL Server Management Studio, login into it using default sa userid, right click on database and click on attach and attach your db files from there ..

Thanks and Regards
Madhu

Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Thiru on: 3/5/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Madhu,
Thanks for your valuable reply.

While attaching the database i am getting the following error:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Attach database failed for Server 'THIRU\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

The database 'D:\MY PROJECTS\ASP.NET TEACHING\TUTORIAL 2.0 WEBSITES\MEMBERSHIP18\APP_DATA\ASPNETDB.MDF' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.
Could not open new database 'D:\MY PROJECTS\ASP.NET TEACHING\TUTORIAL 2.0 WEBSITES\MEMBERSHIP18\APP_DATA\ASPNETDB.MDF'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=948&LinkId=20476

It seems version issue.
What to do now ?
thanks & regards,
Thiru


Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Madhu.b.rokkam on: 3/6/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
I think you have the sql server 2008 DB files .. If that is the case you can download the express edition of SQL Server 2008 also from Microsoft site and try the same..

Thanks and Regards
Madhu

Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response