What is the MSSQL File Extension...How i create a MSSQL database....is it same as MS Access DB?

Question

What is the MSSQL File Extension...How i create a MSSQL database....is it same as MS Access DB?

Answer 1

The MSSQL file extension is .Mdf although you can only create and use them within a MS SQL Database tool such as Enterprise Manager, SQL Server Manager, Vistual Studio, etc..

They are both relational databases but SQL Server is much more robust.

Answer 2

The file extension you are looking for is .sql

It is not the same as Access but I think what you are asking is how to create it from scratch.  SQL is a big language and you can hand code it or look for a UI program to do it for you.  I think one of them is called navicat...  I think the link is simply navicat.com

Answer 3

No. MS SQL is Microsoft SQL Server.

Although there are ODBC drivers readily available for both so one could in theory switch between the 2 of them very quickly.

Answer 4

MSSQL stands for Microsoft SQL (in relation to MSSQL server).  SQL stands for Structured Query Language.  It is similar to an access database but rather than being a simple file it is more of a service that is available accross the network to allow sharing and multiple editing, and much more powerful enterprise database features than just a plain old mdb file.  You can create a database on an MSQL server using the special tools that come with it.  Some here refer to SQL files, these arent the database itself, these are just scripts to automate an SQL database.

Because SQL server is a large enterprise thing it comes with a large price tag.  However you may want to consider a muich more scaled down version which is free.  This is the MSSQL Desktop engine.  This MSSQL is the standard MSSQL server but has some restrictions.  The restrictions relate to only a few people being able to connect to it and the network connections are off by default.  It is mainly used by developers looking to create standalone databases for their application on a PC.

Hope this helps

Answer 5

MS SQL database has an extension of .pdb

It is different from creating a database in MS access but it is also easy to create a database using MS SQL server... The latest version of it is MS SQL server 2008... There are simple one line commands which need to be executed...