access to sql server

hello guys,
i am moving from using access database to use SQL server...i ve never used it before! is there anything difficult in using it?
and do i have only to change the connection string?
actuelly i dont know even how to upload the sql server database to the hostmare there any setting has to be done?...is it one file ? or more? where can i find it if i am using sqlserver evaluation ? and can the connection string point directly to the physical path of the database -in case it is one file and if it is possible-
one more thnik please...does sql server have reporting services (like crystal reports) so i can export the data to a pdf or excel?
and the last...is is there anyway for just simply convert a dataset to pdf...
iknow it is a lot of questions...but i feel moving to sql server is very hard...and i hope it is not!
thanks in advancedHere are some opinions:

msadekd wrote:

i am moving from using access database to use SQL server...i ve never used it before! is there anything difficult in using it?
and do i have only to change the connection string?

The answer is: it depends. :-) If you stuck with ANSI syntax thereshouldn't be too much you have to change as far as the physcialqueries, etc. are concerned. But on the ADO.NET end, you willlikely want to use SqlClient instead of OleDb to talk to your databaseas SqlClient is fine-tuned for SQL Server.

msadekd wrote:

actuelly i dont know even how to upload the sql server database to thehostmare there any setting has to be done?...is it one file ? ormore? where can i find it if i am using sqlserver evaluation ? andcan the connection string point directly to the physical path of thedatabase -in case it is one file and if it is possible-

On way is to use SQL Enterprise Manager to transfer your databaseobjects from your local server to the host's server. See my posthere on how to copy your database objects to your host:http://forums.asp.net/1036946/ShowPost.aspx.

one more thnik please...does sql server have reporting services(like crystal reports) so i can export the data to a pdf or excel?

There is something calledSQL Server Reporting Services, and this integrates with Visual Studio .NET.

and the last...is is there anyway for just simply convert a dataset to pdf...

I don't know the answer to this question; I haven't played with that myself.