pooja
Reputation: 107
How to import .MDF.SQL file into SQL Server Management Studio?
I have database.mdf.sql file I want to import into Microsoft SQL Server Management Studio. I don't know how to import that file and add tables of that file into new database file.
Upvotes: 0
Views: 7755
Answers (2)
Jithin John
Reputation: 17
USE [master] GO CREATE DATABASE [database_name] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\.mdf' ), ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\.ldf' ) FOR ATTACH ; GO
Upvotes: 0
Related Questions
- SQL Server: Importing database from .mdf?
- Loading .mdf/.mdv file into SQL Server Management Studio
- How to convert a database file (.sql) to a .mdf file?
- How to convert .sql file into .mdf file?
- how to attach .mdf file to sql server 2008 EXPRESS
- Import data from Microsoft SQL (.MDF) file into MySQL
- Convert SQL Server .mdf file format
- How to import a SQL file into SQL Server 2008 using Visual Studio 2010?
- SQL Server MDF file
- Importing a MDF file into SQL Server 2008?