Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1704 > unrolled thread

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

Back to article view | Back to comp.databases.ms-sqlserver

Contents

  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

#1704 — I have a database mdf made in Sql Server 2008 on a Vista machine.

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.
I will be able to use this database on VisualStudio VS2013 (localdb)v11.0
When I use the script from Generates script and run this in VS 2013 I get 
all the meta data but no real data.
I can just see the tables with the columns and so on but no data.

So how can I extract data from a Sql Server database 2008 that is run on a 
vista machine and then use
run the sql scrip on Window 7 machine with (localdb)v11.0.

This works with the Northwind.sql script that I have downloaded.


//Tony 

[toc] | [next] | [standalone]

#1705

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

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-sqlserver

csiph-web