sql server (alternate):
I got a big Access file (1 400 tables) to convert to SQL and I would like to be provided with some automated tools, except upsizing wizard and DTS, to convert it on my own. I got a lot of forms and query to convert too. Can someday provide me with at least one tool name ? Thanks,
Hi AFAIK the upsizing wizard is about your only option. SQL Server does not have forms, these will remain in the access database/project. Have you tried the wizard? If yes does it produce any errors? John [quoted text, click to view] "Guy" <guy@graphic-designer.com> wrote in message news:e04bda98.0311280614.523730ea@posting.google.com... > I got a big Access file (1 400 tables) to convert to SQL and I would > like to be provided with some automated tools, except upsizing wizard > and DTS, to convert it on my own. > > I got a lot of forms and query to convert too. > > Can someday provide me with at least one tool name ? > > Thanks, > > Guy
Also... You may want to post to the access news group! John [quoted text, click to view] "Guy" <guy@graphic-designer.com> wrote in message news:e04bda98.0311280614.523730ea@posting.google.com... > I got a big Access file (1 400 tables) to convert to SQL and I would > like to be provided with some automated tools, except upsizing wizard > and DTS, to convert it on my own. > > I got a lot of forms and query to convert too. > > Can someday provide me with at least one tool name ? > > Thanks, > > Guy
John, The wizard did a little bit of the job (a lot to complete), but nothing is available to help me finish conversion, moreover with forms and query. What' the Access newsgroup URL ? Thanks, Guy *** Sent via Developersdex http://www.developersdex.com ***
Hi Either: comp.databases.ms-access microsoft.public.access.* Your forms will need to remain in the access database or an access project, they is no equivalent in SQL server. John [quoted text, click to view] "Guy Yug" <guy@graphic-designer.com> wrote in message news:3fc76a10$0$88386$75868355@news.frii.net... > > John, > > The wizard did a little bit of the job (a lot to complete), but nothing > is available to help me finish conversion, moreover with forms and > query. > > What' the Access newsgroup URL ? > > Thanks, > > Guy > > > *** Sent via Developersdex http://www.developersdex.com *** > Don't just participate in USENET...get rewarded for it!
Guy, www.upsizewizard.com has the tool to convert Access Queries(even with form parameters) to SQL stored procedures.
On Fri, 28 Nov 2003 17:10:42 GMT, "John Bell" [quoted text, click to view] <jbellnewsposts@hotmail.com> wrote: >Hi > >Either: > >comp.databases.ms-access >microsoft.public.access.* > >Your forms will need to remain in the access database or an access project, >they is no equivalent in SQL server. > >John > > >"Guy Yug" <guy@graphic-designer.com> wrote in message >news:3fc76a10$0$88386$75868355@news.frii.net... >> >> John, >> >> The wizard did a little bit of the job (a lot to complete), but nothing >> is available to help me finish conversion, moreover with forms and >> query. >> >> What' the Access newsgroup URL ? >> >> Thanks, >> >> Guy >> >> >> *** Sent via Developersdex http://www.developersdex.com *** >> Don't just participate in USENET...get rewarded for it! > Do you mean you want the forms / queries to remain in access but use sql server as a source of tables, or do you want to convert them to something else? Either way you might find this link helpful http://www.microtools.us/ It's a tool that purports to convert an access application to an
Thanks for your time and info., I'll have a tour of this tool soon. Guy [quoted text, click to view] wizard@upsizewizard.com (upsizewizard) wrote in message news:<c63ed6cf.0311281820.7f97e654@posting.google.com>... > Guy, > > www.upsizewizard.com has the tool to convert Access Queries(even with > form parameters) to SQL stored procedures. >
[quoted text, click to view] On 30 Nov 2003 08:57:53 -0800, guy@graphic-designer.com (Guy) wrote: >Thanks for your time and info., > >I'll have a tour of this tool soon. > >Guy > >wizard@upsizewizard.com (upsizewizard) wrote in message news:<c63ed6cf.0311281820.7f97e654@posting.google.com>... >> Guy, >> >> www.upsizewizard.com has the tool to convert Access Queries(even with >> form parameters) to SQL stored procedures. >> >> wizard Hmmmm $10.000 dollars to convert a Access Database to SQL kinda pricey
[quoted text, click to view] Lyndon Hills <lyndon@nospam.tenegi.com> wrote in message news:<66dfsvsdabl8u0k4baobg71df0p4fhurjs@4ax.com>... > Do you mean you want the forms / queries to remain in access but use > sql server as a source of tables, or do you want to convert them to > something else? Either way you might find this link helpful > > http://www.microtools.us/ > > It's a tool that purports to convert an access application to an > asp.net one. Has anyone actually use this Microtools converter? Is it good? Regards,
Hi Guy, My application generator for MS SQL Server can do the entire job for you The benefits of this system are as follows: 1. The system generates true Client Server and Multi Tier applications. 2. There is zero coding for common functionality, i.e. Adds, Updates, Deletes, Audit trail, Security, Rolling Down Data, Cascading Deletes, Posting to General ledger etc. 3. There is zero work of any kind for generation of data entry screens and their lookups. 4. The back end is completely independent from the front end. You can hit the database with any application or user interface and still be sure that you have complete security and valid data. 5. Easy navigation through out the application. The generated user interface is a familiar modern metaphor with a navigation tree on top or at the side and data entry screens at the bottom. Also, the generated user interface remembers customizations to each data entry screen. This allows you to make sweeping changes to the interface, and regenerate all data entry screens, without loosing your customizations. 6. Consistent look and feel via OOP Inheritance and code generators. 7. Major changes in look and functionality are made in one place only, and ripple down to all affected parts of the system without programmer intervention. Again, this was accomplished with OOP inheritance and also with code generators. 8. Users to have the ability to create queries and reports on the fly. And the ability to save and reload those queries and reports in many formats including Excel and HTML. 9. Users to have complete flexibility in customizing the look and feel of the system. The extent to which each user can customize the interface must be seen to be believed. This high level of customizability creates a high degree of user acceptance. 10. Logical use of hot keys and local popup menus allow for easy mouse free operation, permitting the user to keep his or her hands on the keyboard, if the user so desires. 11. All custom code added to generated data entry screens and generated backend code persists after regeneration. 12. Comes with a business rule generator 13. Comes with a data import utility 14. Comes with a data revalidation utility to use when you change your business rules. Get all this without programming. If you need to quickly build feature rich, bug free business applications for MS SQL Server, then please call (201 665 8906) or
[quoted text, click to view] guy@graphic-designer.com (Guy) wrote in message news:<e04bda98.0311280614.523730ea@posting.google.com>... > I got a big Access file (1 400 tables) to convert to SQL and I would > like to be provided with some automated tools, except upsizing wizard > and DTS, to convert it on my own. > > I got a lot of forms and query to convert too. > > Can someday provide me with at least one tool name ? > > Thanks, > > Guy
1400 tables? Yikes. Is this thing set up properly? I'd make sure it was before converting anything... Then you could use access as the front and and SQL server as the back... but you might want to read
Yo JohnShear - You still out there? Still offering this software? If so please advise BobAlston9 AT aol D O T com
Don't see what you're looking for? Try a search.
|