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

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

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	2014-03-07 16:59 +0100
Organization	A noiseless patient Spider
Message-ID	<lfcqci$o1m$1@dont-email.me> (permalink)

Show all headers | 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