Wednesday, March 7, 2012

how to create .sdf files ?

For a SS05 database , how to create the corresponding SQL Everywhere .sdf
files ?John A Grandy wrote:
> For a SS05 database , how to create the corresponding SQL Everywhere .sdf
> files ?
In Management Studio click on Connect in the Object Browser. Choose SQL
Server Mobile and specify the file name. I guess that hasn't changed
for Everywhere Edition but I haven't tried it myself.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||I believe you're referring to how to open an existing SQL Mobile / SQL
Everywhere db ( .sdf file )
I need to create a SQL Everywhere .sdf file for an existing SS05 db.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1161719444.886080.104470@.i42g2000cwa.googlegroups.com...
> John A Grandy wrote:
> In Management Studio click on Connect in the Object Browser. Choose SQL
> Server Mobile and specify the file name. I guess that hasn't changed
> for Everywhere Edition but I haven't tried it myself.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>|||"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:%237bAeN79GHA.3392@.TK2MSFTNGP05.phx.gbl...
>I believe you're referring to how to open an existing SQL Mobile / SQL
>Everywhere db ( .sdf file )
> I need to create a SQL Everywhere .sdf file for an existing SS05 db.
>
Apologies. If you click the database file combo box you'll see the option to
create a new database.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

No comments:

Post a Comment