Groups > comp.databases.ms-sqlserver > #1705

Re: I have a database mdf made in Sql Server 2008 on a Vista machine.

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: I have a database mdf made in Sql Server 2008 on a Vista machine.
Date	2014-03-07 21:33 +0100
Organization	Erland Sommarskog
Message-ID	<XnsA2E9DB5F1EE74Yazorman@127.0.0.1> (permalink)
References	<lfcqci$o1m$1@dont-email.me>

Show all headers | View raw

Tony Johansson (johansson.andersson@telia.com) writes:
> If I just go to Sql Server Management Studio and choose task on the
> database and then Generate script I will not get the data from this
> database. 

If you ask for it you will. If you don't ask for it, you will not.

In SSMS 2008 the scripting wizard brings you to the page with scripting
options. One of them is Script Data.

In SSMS 2012 this page is not displayed automatically. You need to press
the the Advanced button in the third screen.

-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

I have a database mdf made in Sql Server 2008 on a Vista machine. "Tony Johansson" <johansson.andersson@telia.com> - 2014-03-07 16:59 +0100
  Re: I have a database mdf made in Sql Server 2008 on a Vista machine. Erland Sommarskog <esquel@sommarskog.se> - 2014-03-07 21:33 +0100

csiph-web