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

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

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	"Tony Johansson" <johansson.andersson@telia.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	I have a database mdf made in Sql Server 2008 on a Vista machine.
Date	Fri, 7 Mar 2014 16:59:10 +0100
Organization	A noiseless patient Spider
Lines	16
Message-ID	<lfcqci$o1m$1@dont-email.me> (permalink)
Mime-Version	1.0
Content-Type	text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding	7bit
Injection-Date	Fri, 7 Mar 2014 15:59:14 +0000 (UTC)
Injection-Info	mx05.eternal-september.org; posting-host="8fdc2b5af81c338deb7045fc6c39b0e2"; logging-data="24630"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+6/4U0muucViJRJ8D3C33v"
X-MimeOLE	Produced By Microsoft MimeOLE V6.0.6002.18463
X-Newsreader	Microsoft Windows Mail 6.0.6002.18197
Cancel-Lock	sha1:Y2hyXuVr7hoHTG0KgcJM/Si1GW0=
X-Priority	3
X-MSMail-Priority	Normal
Xref	csiph.com comp.databases.ms-sqlserver:1704

Show key headers only | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Next 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