0

I have a local .mdf file I use it as a database in my asp.net webforms website, since I don't have Microsoft SQL Server and I have Visual Studio v2015 also I have a connection string here :

Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename="C:\Users\Dark\Documents\Visual Studio 2015\Projects\ITResco\App_Data\ITResco_DB.mdf";Integrated Security=True

So how can I generate its SQL script since I don't have a Tasks -> GenerateScript Command

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Mohammad Al Baghdadi
  • 377
  • 2
  • 21
  • If you're using a `.mdf` file, **YOU HAVE** SQL Server ..... you **cannot** use an `.mdf` file without having a SQL Server engine installed. – marc_s Dec 15 '15 at 05:50
  • i don't have sql server managment application on my pc but i have visual studio which allowes me to make a .mdf file database but it's not full feature of sql server tasks – Mohammad Al Baghdadi Dec 15 '15 at 06:08
  • Then you might need to *download* a copy of SQL Server Management Studio and install it, so that you get that functionality .... – marc_s Dec 15 '15 at 06:10
  • damn it i know the answer will be something like that – Mohammad Al Baghdadi Dec 15 '15 at 06:16
  • 1
    Yeah, unfortunately, it seems even the wastly improved SQL Server Object Explorer in VS 2015 still doesn't have this "Generate Scripts" capability on the database level...... – marc_s Dec 15 '15 at 06:19
  • SQL Management Studio 2015 is a free/independant application (currently in preview, november). should work for what you need, though not sure why you didn't install it with the SQL install. – Tracker1 Dec 15 '15 at 06:55

0 Answers0