CODEWITHSUNDEEP
c#sqlasp.netvisual-studio
Felix Froschauer
Felix Froschauer

Reputation: 93

how to use a .sql file as database

So I recently got an old ASP.NET Web-App from my boss to look into, as I'll be using it for a small project in the future.

The developer of this App defined the following connection-string in the web config: Server=localhost; Database=mbw.sql; Uid=admin; Pwd=pass

I also got the mbw.sql file, but cant seem to figure out what to do with it. I was thinking of adding it as a datasource in Visual Studio, but it doesn't seem to be a valid file for that.

Sorry if this is a dumb question, but I seem to be unable to word my search term correctly for google to give me an answer.

Upvotes: 0

Views: 1528

Answers (1)

Chris Travers
Chris Travers

Reputation: 26474

Maybe they named the database "mbw.sql" and imported the file into that. The first thing I would look at is what driver is being used and from there load the file into that database.

People do sometimes name things in misleading ways. You cannot use an SQL file as a database. This has to be loaded into an RDBMS. So somebody has done something very odd here in naming things.

One of the two hard questions in computer science.

Upvotes: 1

Related Questions