Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ts01
Starting Member
3 Posts |
 Posted - 2006-03-10 : 14:31:29
|
| Hi there,I have been asked buy my boss to try and solve a problem. We have a access database which has a hell of a lot of entries. We want to use sql server to store this database now.We want to be able to print reports and analyze the data by running queries etc.Apart from the obvious sql server software, what would be required to acheive this, would i need a dedicated front end built?Im just testing water at the moment looking for any info that i might need.ThanksTrev |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-03-10 : 14:51:03
|
| There are a lot of possibilites, here's a couple of options.1. Use Access to connect to SQL Server to run reports/queries that may already exist in Access.2. When you instll SQL Server, install Reporting Services as well, use RS to build your reports.3. 3rd party reporting tool (Crystal, etc...)A lot of this depends on your budget, your (or staff) familiarity with various products, your time line, what "a hell of a lot of entries" is, how many users, etc... |
 |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-10 : 14:52:56
|
| Yes, u need a front end (AS VB / .Net / ASP / Java...) May be u can use the Access for reports (if u use the same at the moment)May be a better reporting tool as Crystal ReportsA thorough analysis of the Table structures, Datatypes, Viewss, Queries, etcA db / software personnel to handle thisA way to migrate data |
|
|
|
ts01
Starting Member
3 Posts |
Posted - 2006-03-10 : 14:58:41
|
| Thanks for the info. The reason this has come up is that the database has a list of some of our customers. This bounces between 800 and 950,000 people. The database is 650mb in size and when they change certain things, they get error messages etc. They want the scope to grow the db as they go and i think they are happy with using access as a front end but it would be nice if there was a sql server doing the work rather than the client. There will only be a handfull of users accessing the database so it woyld be pretty basic really.We already have sql server and access licences so it would be good to keep costs down by using these.What sort of work is involved with this, i have installed sql server before but only to assist t/p products not to build my own database. Is it relativly straight forward to do?Thanks for your help.Trev |
|
|
|
ts01
Starting Member
3 Posts |
Posted - 2006-03-11 : 08:50:33
|
| Any info would be great, thanks.Trev |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-11 : 10:45:49
|
| Did you install the MS SQL Server for this task ? If not do it.Read the Books OnLine (Help file of SQL Server)Also do u have a good idea of the objects / elements / table structures ... of the Access DB. If u don't, then u have to identify those.What specific info u need?U asked only one question >> Is it relativly straight forward to do?Answer depends on the relative straight forwardness of uFo me its not that straight forward!!There is no magical tool or mechanism to convert all Access stuff to SQL server.U might need to search thru this site (or the web) on Database moving from Access to SQL Server. |
|
|
|
|
|
|
|
|
Newbie need some info