Going from ASP to ASP.NET

Report · Nov 17, 2008

Hi All,

I have been developing using ASP with VBScript and MS Access for a long time. I am now thinking about moving to ASP.NET using MS SQL. I'm really not familiar with MS SQL...is it similar to Access, meaning do I need a copy of MS SQL to work from (crearing tables, relationships, etc...) before uploading to the server via FTP? Or can I work from Access and then convert to MS SQL? How does that work?

Are there tools or articles I can read about this?

Report · Nov 17, 2008

The only general similarity between SQL Server and Access/JET is they are
both relational databases. SQL Server is where the "big boys" play. You
should download the free release of SQL Server Express.

Similarly, now that you've cut your teeth with VBS/ASP and want to wear long
pants you should learn C# as all web development which you have discovered
requires a mastery of JavaScript which has punctuation exactly like C# ad
both derive from C so you learn two (and more) languages for the price of
one so to speak.

"Brachole" <webforumsuser@macromedia.com> wrote in message
news:gfsr5o$qtf$1@forums.macromedia.com...
> Hi All,
>
> I have been developing using ASP with VBScript and MS Access for a long
> time.
> I am now thinking about moving to ASP.NET using MS SQL. I'm really not
> familiar
> with MS SQL...is it similar to Access, meaning do I need a copy of MS SQL
> to
> work from (crearing tables, relationships, etc...) before uploading to the
> server via FTP? Or can I work from Access and then convert to MS SQL? How
> does
> that work?
>
> Are there tools or articles I can read about this?
>

Report · Nov 18, 2008

Brachole wrote:

> I'm really not familiar with MS SQL...is it similar to Access,
> meaning do I need a copy of MS SQL to work from (crearing tables,
> relationships, etc...) before uploading to the server via FTP?

First you not be able to upload data to MSSQL as you do with Access.
With Access you can up ftp the database, not so with MSSQL. How you
move your data up depends on the hosting and what tools they allow.
Some allow remote management using Enterprise Manager and other only
allow their own online tools for you to import or run scripts to
facilate importing of data and tables. So, first do research on your
hosting setup.

> Or can
> I work from Access and then convert to MS SQL? How does that work?

You don't want to do this, you will only be asking for many headaches.

Report · Nov 18, 2008

>> Or can
>> I work from Access and then convert to MS SQL? How does that work?
>
> You don't want to do this, you will only be asking for many headaches.

I have done this before, its a function built into Access, you have to
be careful with data types and thats about it.

If your host allows it you can even access your MSSQL database from
Access via a project file. Allows you to work on it like you would an
Access database, but there are some differences, and its not the
preferred method, but I did ok for several years that way.

Dooza
--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html

Report · Nov 18, 2008

On 18 Nov 2008 in macromedia.dreamweaver.appdev, Philo wrote:

> Brachole wrote:
>
>> I'm really not familiar with MS SQL...is it similar to Access,
>> meaning do I need a copy of MS SQL to work from (crearing tables,
>> relationships, etc...) before uploading to the server via FTP?
>
> First you not be able to upload data to MSSQL as you do with Access.
> With Access you can up ftp the database, not so with MSSQL. How you
> move your data up depends on the hosting and what tools they allow.
> Some allow remote management using Enterprise Manager and other only
> allow their own online tools for you to import or run scripts to
> facilate importing of data and tables. So, first do research on your
> hosting setup.
>
>> Or can
>> I work from Access and then convert to MS SQL? How does that work?
>
> You don't want to do this, you will only be asking for many
> headaches.

Actually, you can use Access as a front end for SQL Server. As
somebody noted, you have to be careful about data types - they're not
the same. Search Access's help for 'ADP' for information on how to do
this.

What is a Microsoft Access Project?

A Microsoft Access project (.adp) is an Access data file that
provides efficient, native-mode access to a Microsoft SQL Server
database through the OLE DB (OLE DB: A component database
architecture that provides efficient network and Internet access to
many types of data sources, including relational data, mail files,
flat files, and spreadsheets.) component architecture. Using an
Access project, you can create a client/server application as
easily as a file server application.

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/contact.php

Report · Nov 19, 2008

thanks guys. Gret information. I guess I'll just jump in and see what happens.

Report · Nov 20, 2008

>
> Actually, you can use Access as a front end for SQL Server. As
> somebody noted, you have to be careful about data types - they're not
> the same. Search Access's help for 'ADP' for information on how to
> do this.
>

Just why do you want to do it? Using mssql all the way will reduce
problems during development. This could be another one of those
personal perferences, but....

Report · Nov 20, 2008

Philo wrote:
>> Actually, you can use Access as a front end for SQL Server. As
>> somebody noted, you have to be careful about data types - they're not
>> the same. Search Access's help for 'ADP' for information on how to
>> do this.
>>
>
> Just why do you want to do it? Using mssql all the way will reduce
> problems during development. This could be another one of those
> personal perferences, but....

Using Access with a Project file pointed to an SQL server can smooth the
transition, as you are using tools that you are comfortable with. You
can do lots but not everything, so once you get the stage where you
can't do something you download Enterprise Manager or Server Studio
Management thingy and and start learning. I rarely use Access now, but
it does have a couple of benefits over the standard tools. For instance,
when looking at the contents of a table or view, you have sorting
options, and filter options, plus built in search facility. With the
standard tools you have to view the sql and write these your self.
Access as a project makes it simpler and quicker to do certain tasks.

Dooza
--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html

Report · Nov 22, 2008

Good points/considerations for those who are familiar with Access.
However I stick'n to my story. :>)