Sql mobile - create table script

[Tom]

Hi,

I'm confused with one task. I'm working with sql server mobile. I've created
a database (sdf) and now I want to create sql script that will reproduce
tables from sdf database in an another database (sql server).

I cant find any option like "Export" in Sql Server Management Studio when I
select my sdf database in Sql Server Mobile tab. Please help

greetings,
Tom

 

[Guest]

Hi Tom,

SQL Server Management Studio does not contain any options for 'Script
Database as' or 'Script Table as' when working with SQL Mobile, as opposed to
working with SQL Server.

In lieu of writing your own mechanism to script out your database, take a
look at the Data Port Wizard from PrimeWorks (
http://www.primeworks-mobile.com/Products/DataPortWizard.html ). There are
some other mechanisms that I have seen used for this (setting up replication
being one of them), but they can be a bit involved.

Also, any SQL Mobile/SQLce questions you have would be better answered in
the microsoft.public.sqlserver.ce group which is easily accessible from MSDN
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.ce&lang=en&cr=US

or via Google Groups
http://groups.google.com/group/microsoft.public.sqlserver.ce