More Group Sites
School Rankings
Jobless Net
Better Home
Enviro++


Help | Subscribe/Unsubscribe | Rules | Other Group Sites: Better Education | Better Education Forum
Welcome Guest Search | Active Topics | Members | Log In | Register

Generate schema and data scripts for sql server ce 3.5 in sql server management studio 2008 express Options · View
hong
Posted: Tuesday, August 03, 2010 3:07:32 PM

Rank: Administration
Groups: Administration

Joined: 11/23/2008
Posts: 329
Points: 693
Location: Australia
Visual Studio 2008 and SQL Server Management Studio don't support data and schema scripts for sql server ce 3.5. However, thanks to CodePlex, an open source community, you can down load an add-in for sql sever management studio 2008 express to support scripting for sql server compact 3.5 like other sql server editions:

The following menu items are added to the table context menu in Object Explorer by the add-in:
- Show Table Data (browse, sort, edit, import/export/delete images, refresh data)
- Script Table as CREATE, DROP, SELECT, INSERT, UPDATE, DELETE and INSERTs (data) to New Query Editor, Windows, File or Clipboard
- Import Data from CSV
- Rename

Personally I missed "Show Table Data" and "Rename' dearly. Now they are back together with powerful scripting functions and data import from CSV files. Moreover, I can "Script Database" and "Script Server Database" using the menu items added to the database context menu:

Download the add-in here.

Related:
SQL Server Management Studio 2008 add-ins:
SSMS 2008 Addin - Data Scripter allows you to generate INSERT statements for all values of a table easily. Just select Script
Data as from the context menu of the table and choose one of the options

- INSERT: Insert statements without column names are generated
- INSERT with column names
Download it now: SSMS 2008 Addin - Data Scripter

Full Text Manager allows you to manage your fulltext catalogs easily. It even works for SQL Server Express editions.

For more information, visit project page: http://www.codeplex.com/FulltextManager.

Sponsor
Posted: Tuesday, August 03, 2010 3:07:32 PM
hong
Posted: Tuesday, August 03, 2010 6:09:17 PM

Rank: Administration
Groups: Administration

Joined: 11/23/2008
Posts: 329
Points: 693
Location: Australia
It seems that the script created got IDENTITY missing. You may need to add Identity manually.
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

ASPNET Theme created by Boskone (Dan Ferguson)
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.
This page was generated in 0.252 seconds.