linq to sql - Copy SQL Server Express table to SQL Server CE table for vs2012 -


i using visual studio 2012 , trying import or copy table sql server 2008 express database local db using sql server compact edition vs2012.

i have found there no management support in sql server management studio 2012 / 20008 visual studio 2012 sql server ce local db.

they management interface can use visual studio 2012 professional edition.. can access both db's with.

but when try copy table vs2012 using following sql ce sql new query command..

 insert sqlcedbname.dbo.testdata       select * sql2008dbname.dbo.testdata     (both tables same name)

it not give me data -- , acts can't find database name ignores them , thinks want copy ce table 'cetable' 'cetable'

both tables in sql server 2008 r2 , vs2012 ce exact structure , name.. ce table not have data in it.

also -- (vs2012 ce support) -- not read sql script file created in 2008 ssms either.

use sql server compact toolbox add-in, allows script single server table w data - right click "root" tree node connect , export data sql server database.


Comments

Post a Comment

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more

rewrite - Trouble with Wordpress multiple custom querystrings -

i'm working on adding multiple querystring , doesn't seem work. i've found codes seems work others might i'm missing something. i want like: http://mydomain.com/board/?getyear=2013&getsometext2=sometext to http://mydomain.com/board/2013/sometext/ i added code below functions.php file. doesn't seem work should though. this works. echoing querystring gets both variable without problem. http://mydomain.com/board/2013/sometext/ but doesn't. tested querystring vis isset() seems nothing being set/get http://mydomain.com/board/2013/ function add_query_vars($vars) { $vars[] = "getyear"; $vars[] = "getsometext2"; return $vars; } add_filter('query_vars', 'add_query_vars'); function add_rewrite_rules($arules) { $anewrules = array('board/([^/]+)/([^/]+)/?$' => 'index.php?pagename=board&getyear=$matches[1]&getsometext2=$matches[2]'); $arules = $a...
Read more