I have this SQL Server CE database that I would like to convert to a SQL Server 2008 database because I want it to be accessible over the network. I am using SQL Server 2008 Express and VB9.
Any idea?
A simple way would be to go to SQL Management Studio (I think it can connect to SDF files?) And right-click on it, and there will be a script database in the actions in the text file. This will give you SQL scripts to create the schema, and then you can create them in SQL 2008.
, SQL Server Management Studio . SQL Server 2005 Management Studio Express, , Service Pack2 , . Management Studio 2005 sdf. 2008 Express.