If I work in development with express 2008 and my ISP have SQL SERVER 2005
will I have problems publishing?
TIA
BARAK

It depends....

The database files are not directly compatible. However, if you stick to data types supported by SQL Server 2005, you should be able to script your database and run them against the target server.

However, just to be safe, it's probably easier to install 2005 side by side as well.

Cheers,

Imar
---------------------------------------------------------------------------------------------------------------------
Imar Spaanjaars
Web: Imar.Spaanjaars.Com Twitter: ImarSpaanjaars.

Author of Beginning ASP.NET 4 : in C# and VB, Beginning ASP.NET 3.5 : in C# and VB, and ASP.NET 2.0 Instant Results.
While typing this post, I was listening to: Special Cases by Massive Attack (Track 4 from the album: 100th Window) What's This?

I am missing some stuff in the installation of the SQL express 2005 like publish and also I can’t script table’s data - the feature is just not there...

I tried upgrade but the installation stop since no updates were found to install... I don’t want to remove the installation since I have done a lot of work on this tables and I can't back them up.... (I can backup only the scheme)

any suggestions?

Why can't you back them up? You can simply create a copy of the .mdf file...

Have you tried installing SQL Server Management Studio Express edition?

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!