Dodsworth
asked on
SQL Server Management Studio doesn't see SQL Compact
I run Management Studio and bring up the Connect to Server dialog. but the drop-down list of Server Names does not include the SQL Server Compact Edition server.
Any ideas ?
SQLMS 2012 v 11.0.2100.60 and SQL Server Compact 3.5 sp2 and 4.0 sp1
Any ideas ?
SQLMS 2012 v 11.0.2100.60 and SQL Server Compact 3.5 sp2 and 4.0 sp1
Kash
what server its installed on. if it is installed on the same machine then type 127.0.0.1 and then try. use local username/password
AFAIK, CE cannot be managed with the Management Console.
In the File > Connect Object Explorer dialog, change the Server Type dropdown to SQL Server Compact Edition.
Then in the Database File dropdown choose New Database.... and you're ready to go.
Then in the Database File dropdown choose New Database.... and you're ready to go.
ASKER
@Eric: the Server Type box is greyed out :(
@Strivoli: I read another post that said that CE support has been removed from SSMS 2012. What am I supposed to used instead ?
@Strivoli: I read another post that said that CE support has been removed from SSMS 2012. What am I supposed to used instead ?
You can use Visual Studio, you can try the Express edition.
You can look through codeplex to see if you like any of the tools there also.
e.g., http://sqlcetoolbox.codeplex.com/
You can look through codeplex to see if you like any of the tools there also.
e.g., http://sqlcetoolbox.codeplex.com/
ASKER
OK I have Visual Studio but can't see where to create a new db ?
Use the 2005 Management... details in the next post in about a couple of minutes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use the Server Explorer tab to access the menu to add connection to SQL compact edition, or create new database.
In addition, here are some nice walk-through articles on MSDN:
http://msdn.microsoft.com/en-us/library/gg606540(v=vs.100).ASPX
http://msdn.microsoft.com/en-us/library/vstudio/bb546200(v=vs.100).aspx
In addition, here are some nice walk-through articles on MSDN:
http://msdn.microsoft.com/en-us/library/gg606540(v=vs.100).ASPX
http://msdn.microsoft.com/en-us/library/vstudio/bb546200(v=vs.100).aspx
ASKER
The create new sql server database option is dimmed out.
Did you look at the information on MSDN? It steps you through the process nicely.
ASKER
In first link
2.In the Add New Item dialog box, select SQL Server Compact 4.0 Local Database
It's not there :(
In second link
2.Select Local Database in the list of available templates.
Not there either !
2.In the Add New Item dialog box, select SQL Server Compact 4.0 Local Database
It's not there :(
In second link
2.Select Local Database in the list of available templates.
Not there either !
What version of Visual Studio do you have?
ASKER
2012 express
Ugh. Like SSMS 2012, I do not believe VS 2012 Express supports CE.
You unfortunately may be stuck installing a different tool. As others said above, older versions of SSMS will work (e.g., SSMS 2005 and SSMS 2008). The tool I linked to in codeplex should work well also.
You unfortunately may be stuck installing a different tool. As others said above, older versions of SSMS will work (e.g., SSMS 2005 and SSMS 2008). The tool I linked to in codeplex should work well also.
ASKER
Really ? How then is anyone supposed to use up-to-date tools to create local databases for Windows Phone ? Data on WP8 is not so much a steep learning curve, more a downward spiral of despair !
They are moving folks towards SQL Express LocalDB (and cloud-based Azure databases I suspect).
http://msdn.microsoft.com/en-us/library/ms233763(v=vs.110).aspx
http://msdn.microsoft.com/en-us/library/ms233763(v=vs.110).aspx
ASKER
Azure Mobile Services is looking promising, but there's no support for LocalDB in WP8 or any sync framework for the times when there's no connection to the internet :(
why not use mySQL and MAMP or phpmyadmin, a lot better free and less hassle.
Did you give Microsoft SQL Server Management Studio Express a try as I suggested you in my last post?