mdf

Where does SQL Server 2005 keep the .mdf files?

I'm upgrading from SQL Server 2005 to 2008. I've detached the database I need, but can't find it on the file system. Where does a default installation of SQL Server 2005 store these? ...

How do I migrate a SQL MDF File to a production SQL Server? (ASP.NET)

I have an ASP.NET project that also uses a SQL MDF File. My target server is SQL 2008R2 or SQL Azure. I would like to know what deployment options I have as I migrate from DEV to PROD. In case it matters I'm not under any regulation to maintain PII or similarly private data. How do I move my test schema and perhaps data to production...

c# Connecting to a local MDF DB File

On my development computer I have MS SQL Server/Visual Studio 2005. My program can correctly connect to my local DB and use it. However my other computer (non-dev) does not have MS SQL Server/Visual Studio 2005 and does not connect to the DB. It spits out the following: "An error has occurrred while establishing a connection to the serv...

Creating DataBase (mdf) from DataSet

I have a DataSet consistint of a big number of tables of information. Is it possible automaticly create SQL Server DataBase (mdf-file) from description of my DataSet? Of course, I can do it manually, but may be there is a better way? ...

sql server mdf file database attachment

hello all i'm having a bear of a time getting visual studio 2010 (ultimate i think) to properly attach to my database. it was moved from original spot to #MYAPP#/#MYAPP#.Web/App_Data/#MDF_FILE#.mdf. I have three instances of sql server running on this machine. i have tried to replace the old mdf file with my new one and cannot get the...

how to export ADO.net entity data model to a .mdf file?

Hi, I've created my first ADO.net entity data model. In it there are 2 tables (with no relations, just simple tables). In my Project's App_Data directory there is an (empty) mdf file called "trans.mdf". When I select "generate database from model" in the ADO.NET model, I can select my "trans.mdf" in the dialog. It then builds the dd...

SQL Server: Importing database from .mdf?

I have an .mdf file on my local box. I have SQL Server 2008 Express and SQL Management Studio 2008 Express installed on my local box. How in the world do I import this .mdf file as a new database into my SQL Server? This seems like a ridiculously common task that must be performed thousands of times a day across the globe, and I canno...

.dbo and .mdf in Visual Web Developer - some kind of mixup

I am really confused about the .dbo schema thing. Here is my issue: I have a website I'm building in VWD and I connected it to a database that I built in SQL Server Management Studio. The website works to pull up items from the database. However, I made changes to the database and they didn't show up in the website. I looked in the Datab...