Design Tools  
Author Message
Default>





PostPosted: Thu Sep 11 18:37:32 CDT 2003 Top

SQL Server Developer >> Design Tools

I have a number of applications written in Access. I need
to scale these applications up. I do like the design
tools built into Access. I would like the ability to
design standalone applications as well as multi-user
database applications. What tool would provide the
development enviornment that is as fast and as good as
Access for use with SQL server, etc.

Visual Basic?
Visual Foxpro?
Native tools to SQL?
Visual Java?

Thanks,
BT
P.S. I do have experience and certification as a DBA in
a "real" database platform.

SQL Server114  
 
 
Kevin3NF





PostPosted: Thu Sep 11 18:37:32 CDT 2003 Top

SQL Server Developer >> Design Tools You could always use an Access Data Project....scale up the data and
continue to develop in Access.

Kevin



> I have a number of applications written in Access. I need
> to scale these applications up. I do like the design
> tools built into Access. I would like the ability to
> design standalone applications as well as multi-user
> database applications. What tool would provide the
> development enviornment that is as fast and as good as
> Access for use with SQL server, etc.
>
> Visual Basic?
> Visual Foxpro?
> Native tools to SQL?
> Visual Java?
>
> Thanks,
> BT
> P.S. I do have experience and certification as a DBA in
> a "real" database platform.


 
 
Terry





PostPosted: Thu Sep 11 19:08:41 CDT 2003 Top

SQL Server Developer >> Design Tools You can use MS Access for GUI with SQL Server 2000 backend (not the greatest
but it works)

Below you've listed 'programming languages' used to write Windows
Applications when in fact all sorts of apps can access SQL Server.

You are looking for a development tool/IDE [Integrated Development
Environment] to build database apps.

The best I've seen [in ten years of windows db dev] is MS Visual
Student.NET. This envirment allows you to write the application itself using
any language supported on the .NET platform [VB, C++, C#, Visual Java,
Javascript, and many others] and from there, using that languages syntax you
can access methods and properties of objects associated with SQL Server that
are build right into .NET libraries.

Happy programming.

P.S. You gotta get off MS Access!





> I have a number of applications written in Access. I need
> to scale these applications up. I do like the design
> tools built into Access. I would like the ability to
> design standalone applications as well as multi-user
> database applications. What tool would provide the
> development enviornment that is as fast and as good as
> Access for use with SQL server, etc.
>
> Visual Basic?
> Visual Foxpro?
> Native tools to SQL?
> Visual Java?
>
> Thanks,
> BT
> P.S. I do have experience and certification as a DBA in
> a "real" database platform.


 
 
Terry





PostPosted: Thu Sep 11 19:19:28 CDT 2003 Top

SQL Server Developer >> Design Tools OOPS! I meant Visual Studio [not student].Net.



> You can use MS Access for GUI with SQL Server 2000 backend (not the
greatest
> but it works)
>
> Below you've listed 'programming languages' used to write Windows
> Applications when in fact all sorts of apps can access SQL Server.
>
> You are looking for a development tool/IDE [Integrated Development
> Environment] to build database apps.
>
> The best I've seen [in ten years of windows db dev] is MS Visual
> Student.NET. This envirment allows you to write the application itself
using
> any language supported on the .NET platform [VB, C++, C#, Visual Java,
> Javascript, and many others] and from there, using that languages syntax
you
> can access methods and properties of objects associated with SQL Server
that
> are build right into .NET libraries.
>
> Happy programming.
>
> P.S. You gotta get off MS Access!
>
>
>


> > I have a number of applications written in Access. I need
> > to scale these applications up. I do like the design
> > tools built into Access. I would like the ability to
> > design standalone applications as well as multi-user
> > database applications. What tool would provide the
> > development enviornment that is as fast and as good as
> > Access for use with SQL server, etc.
> >
> > Visual Basic?
> > Visual Foxpro?
> > Native tools to SQL?
> > Visual Java?
> >
> > Thanks,
> > BT
> > P.S. I do have experience and certification as a DBA in
> > a "real" database platform.
>
>