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 |
|
muke
Starting Member
2 Posts |
 Posted - 2004-11-08 : 21:17:50
|
| A few questions:1. How would you convert 100 database tables from Access to SQL Server 2000? Upwizard?2. How would you convert 60 access forms that are in the db?3. Does Crystal Reports have a converter to convert reports from Access to Crystal Reports? If so, what is it called? If not, any recommendations?Thanks, |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-11-08 : 21:21:42
|
| 1. you can use DTS to import the tables from Access into SQL2. Forms do not exist in SQL Server, it is NOT a tool for designing user interfaces. it is a database server only. 3. No -- crystal reports are very different from Access reports. (well, not totally true -- at the basic level they are pretty similiar but as soon as you get into formatting ,subreports, and all that they are very different).I suspect that you will want to keep Access as your form/report interface, but store your data in SQL Server and link from Access to SQL Server tables. (this is fairly easy to do) Read about Data Access Projects and also Linked Tables in regards to MS Access 2000.- Jeff |
 |
|
|
muke
Starting Member
2 Posts |
Posted - 2004-11-08 : 21:29:33
|
| Jeff,If the client wants to migrate off Access, what is your recommendation for forms and reports? For reports, I think I can "redesign" the reports using Crystal Reports. I am not sure about the forms. Thanks, |
|
|
|
Auric
Yak Posting Veteran
70 Posts |
Posted - 2004-11-08 : 21:31:14
|
| Muke...You can use VB to design the database frontend, or continue to use Access and just link the tables. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-08 : 21:48:48
|
| As an aside, unless you're already deep into Crystal Reports (monetarily speaking) I would suggest using Reporting Services instead. If you have SQL Server 2000, you're already licensed, so it's basically free, and it is much easier to use than Crystal is. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-11-08 : 21:49:38
|
| The question is: what skills do you have in programming? YOu can use vb 6, vb.net, C#, C++, even HTML/ASP (web server based) and all that. there might be some light-weight form designer apps out there as well that you can bind to a database fairly easily (ie., drag and drop and wizards and all that), but I have never seen/used a product like that.- Jeff |
|
|
|
|
|
|
|
|
Converting from Access to SQL Server 2000