|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Sybase to AccessI'm working on a Visual Basic .NET using Access database. However, my
client already have a 30MB database with Sybase ASA and Sybase is way too much for that. Is there anyway I can migrate from a Sybase to Access? or is it possible at all. If it is not, can these two databases co-exist together? see
http://72.14.205.104/search?q=cache:y_x6ncJ2vKwJ:www.datadirect.com/download/eval_docs/dotnet_sybase.pdf+.NET+sybase&hl=en&gl=us&ct=clnk&cd=3 Show quoteHide quote "codercode" <wong.ja***@gmail.com> wrote in message news:1166120551.784318.13300@80g2000cwy.googlegroups.com... > I'm working on a Visual Basic .NET using Access database. However, my > client already have a 30MB database with Sybase ASA and Sybase is way > too much for that. Is there anyway I can migrate from a Sybase to > Access? or is it possible at all. If it is not, can these two databases > co-exist together? > Are you ending your career with that client, advising Access, while there
are 2 free SQL servers which do a better job? Just my thought reading your message, Cor Show quoteHide quote "codercode" <wong.ja***@gmail.com> schreef in bericht news:1166120551.784318.13300@80g2000cwy.googlegroups.com... > I'm working on a Visual Basic .NET using Access database. However, my > client already have a 30MB database with Sybase ASA and Sybase is way > too much for that. Is there anyway I can migrate from a Sybase to > Access? or is it possible at all. If it is not, can these two databases > co-exist together? > LOL
Show quoteHide quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:uMrpd6AIHHA.2632@TK2MSFTNGP06.phx.gbl... > Are you ending your career with that client, advising Access, while there > are 2 free SQL servers which do a better job? > > Just my thought reading your message, > > Cor > > "codercode" <wong.ja***@gmail.com> schreef in bericht > news:1166120551.784318.13300@80g2000cwy.googlegroups.com... >> I'm working on a Visual Basic .NET using Access database. However, my >> client already have a 30MB database with Sybase ASA and Sybase is way >> too much for that. Is there anyway I can migrate from a Sybase to >> Access? or is it possible at all. If it is not, can these two databases >> co-exist together? >> > > Not sure of the question.
1.) Access would really bite with a 30MB database--not recommended. 2.) Access could use link tables to link to Sybase perhaps and give you "access" to it. then again, why would you use Access if that were possible instead of just getting the drivers to connect directly to Sybase. 3.) If it is a problem you might consider migrating to MySQL. Show quoteHide quote "codercode" <wong.ja***@gmail.com> wrote in message news:1166120551.784318.13300@80g2000cwy.googlegroups.com... > I'm working on a Visual Basic .NET using Access database. However, my > client already have a 30MB database with Sybase ASA and Sybase is way > too much for that. Is there anyway I can migrate from a Sybase to > Access? or is it possible at all. If it is not, can these two databases > co-exist together? > Why would Access bite with a 30MB database -- that's nothing.
I've had apps with an Access database that was 500MB, and the performance was fine. It would be better to migrate to SQLServer Express, but using Access won't kill him. Robin S. --------------------------------- Show quoteHide quote "sstory" <noth***@no.com> wrote in message news:uLrM4NpLHHA.4848@TK2MSFTNGP04.phx.gbl... > Not sure of the question. > > 1.) Access would really bite with a 30MB database--not recommended. > 2.) Access could use link tables to link to Sybase perhaps and give > you "access" to it. then again, why would you use Access if that were > possible instead of just getting the drivers to connect directly to > Sybase. > 3.) If it is a problem you might consider migrating to MySQL. > "codercode" <wong.ja***@gmail.com> wrote in message > news:1166120551.784318.13300@80g2000cwy.googlegroups.com... >> I'm working on a Visual Basic .NET using Access database. However, my >> client already have a 30MB database with Sybase ASA and Sybase is way >> too much for that. Is there anyway I can migrate from a Sybase to >> Access? or is it possible at all. If it is not, can these two >> databases >> co-exist together? >> > > |
|||||||||||||||||||||||
Other interesting topics