Question Regarding SQL Express

[chesneydevine]

Hello,
Our company currently uses Microsoft Access, we will be upsizing to
SQL Express. I am the Database Specialist so I am one of the few
employees that see the back end of the database, everyone else uses
Gopher.

I have to perform routine tasks by pulling information from the MAIN
database we have. So I have another database that is linked to the
main one, that is filled with tables of information and queries
(action queries, append queries, delete queries, select queries, etc).

My question is, will everything have to be retyped out in code each
time when I want to pull my information or can I do something like the
'seperate database' i have that i can just click on a query and it
will run for me.

I've tried to be as clear as possible...so I apologize if it's
confusing!

Thank you
~Chesney

 

[William Vaughn \(MVP\)]

I expect that you need to do a bit of reading on SQL Server architectures
before venturing out on this project. SQL Server databases are generally not
linked together like Access/JET databases. While it's possible, its usually
not necessary. It's entirely possible to create an application to execute
specific queries on demand and it's not at all hard to do. I really think my
book would answer a lot of your questions and help make your transition a
success.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________