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.

Access Table conversion

how difficult is it to convert access tables to SQL that can continue to be
linked to an Access GUI.
Mike,
trivial...there is an Access Upsizing tool in Access that will convert
the data to MS SQL and then you can change your app to read these
tables via ODBC. If you have hard coded access to the tables in your
access app you need to change them to recordsets accessed via
ODBC...that's about it...when we did this on a small system many
years ago we got it done by a fresh uni grad and he only took a couple
of days....
Peter

Access Table conversion

how difficult is it to convert access tables to SQL that can continue to be
linked to an Access GUI.Mike,
trivial...there is an Access Upsizing tool in Access that will convert
the data to MS SQL and then you can change your app to read these
tables via ODBC. If you have hard coded access to the tables in your
access app you need to change them to recordsets accessed via
ODBC...that's about it...when we did this on a small system many
years ago we got it done by a fresh uni grad and he only took a couple
of days....
Peter

Access migration to SQL Server

Hi,
I am deciding which database i should use for my application. One of the
factors that i will use is how easy/difficult it is to migrate from access to
SQL Server / SQL Express Edition.
I'd appreciate any view on this and any links to relevant websites.
Thanks in advance,
Macca
Macca
BOL has pretty good articles about how to create linked server to SQL Server
from Access as well as using DTS Packages to import data from Access.
"Macca" <Macca@.discussions.microsoft.com> wrote in message
news:261D2916-B3B9-4BE9-81C4-47084C12F194@.microsoft.com...
> Hi,
> I am deciding which database i should use for my application. One of the
> factors that i will use is how easy/difficult it is to migrate from access
> to
> SQL Server / SQL Express Edition.
> I'd appreciate any view on this and any links to relevant websites.
> Thanks in advance,
> Macca

Access migration to SQL Server

Hi,
I am deciding which database i should use for my application. One of the
factors that i will use is how easy/difficult it is to migrate from access to
SQL Server / SQL Express Edition.
I'd appreciate any view on this and any links to relevant websites.
Thanks in advance,
MaccaMacca
BOL has pretty good articles about how to create linked server to SQL Server
from Access as well as using DTS Packages to import data from Access.
"Macca" <Macca@.discussions.microsoft.com> wrote in message
news:261D2916-B3B9-4BE9-81C4-47084C12F194@.microsoft.com...
> Hi,
> I am deciding which database i should use for my application. One of the
> factors that i will use is how easy/difficult it is to migrate from access
> to
> SQL Server / SQL Express Edition.
> I'd appreciate any view on this and any links to relevant websites.
> Thanks in advance,
> Macca

Access migration to SQL Server

Hi,
I am deciding which database i should use for my application. One of the
factors that i will use is how easy/difficult it is to migrate from access t
o
SQL Server / SQL Express Edition.
I'd appreciate any view on this and any links to relevant websites.
Thanks in advance,
MaccaMacca
BOL has pretty good articles about how to create linked server to SQL Server
from Access as well as using DTS Packages to import data from Access.
"Macca" <Macca@.discussions.microsoft.com> wrote in message
news:261D2916-B3B9-4BE9-81C4-47084C12F194@.microsoft.com...
> Hi,
> I am deciding which database i should use for my application. One of the
> factors that i will use is how easy/difficult it is to migrate from access
> to
> SQL Server / SQL Express Edition.
> I'd appreciate any view on this and any links to relevant websites.
> Thanks in advance,
> Macca