How to import data in SQL Compact Edition?

sql-server import sql-server-ce
Peter picture Peter · Oct 6, 2009 · Viewed 23.4k times · Source

I don't seem to find a tool for it, nor an odbc driver.

Thanks

UPDATE : I'm aware of the sql scripting possibilities. But than again : how to script a sql 2k table? (not just ddl, but data also?)

Of course you can write this all by yourself, but importing data into CE cannot be such a hassle, or can it ?

UPDATE2 : I don't seem to be able to choose the right dialect for inserting

Answer

Julien Lebosquain picture Julien Lebosquain · Oct 6, 2009

You can use SQL Server Management Studio Express which also allows the connection to SQL Compact databases. You'll then be able to execute any *.sql file easily that have data exported from elsewhere.

Edit (response to update): I don't know if you can connect to a SQL Server 2000 with SSMS 2008, but if you can, right click on your database in SSMS, choose Tasks > Generate Scripts, and in the options on the second page, scroll down and change "Script Data" to True.

Related questions

Import Excel spreadsheet columns into SQL Server database

I have an Excel spreadsheet that I want to import select columns into my SQL Server 2008 database table. The wizard didn't offer that option. Do any easy code options exist?

Read More
Import / Export database with SQL Server Server Management Studio

I thought this would be trivial, but it isn't... I'm sure there is a simple way to do it but I can't manage to find it. Shame on me. I want to import/export the database itself, the tables, the …

Read More
How to import an Excel file into SQL Server?

I have data in an Excel file - actually xlsx format since it is now 2020. My requirement is to get this data into SQL Server as follows: ad hoc, the use-case being feeding tables with test data, or infrequent data …

Read More