Sql mobile - create table script

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
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
 
Back
Top