allows you to move the tables to sql and to even keep them in your access
database.
Now last time I used this product was Sql 6.5- years ago. There was some
weirdness that I would test for if I were you. Make a backup of a table
then use the uplink mgr to test.
1. The y/n fields became bit fields. The bit fields could not be null. I'm
pretty sure that doesn't do that anymore, but can't say for sure. Anyways
that leads to problems-we were using that field with checkboxes- suddenly
all my non checked boxes wigged out.
2. The database I was uplinking wasn't one I designed. The designer did
some things that worked with Access/but not in sql at the time (ie: Field
names with # or spaces other weirdness). Make sure your field names comply
with SQL.
3. Most of the time sql does keep it pretty close, but I notice that
sometimes it'll want to change a field type. Like a text field may become a
nvarchar field. You'll want to go into the sql end and change those to
varchar.
Otherwise the uplink manager is easy to use. If you're using something
lower than Access2000 you can get the uplink manager off of microsoft site.
If you have access2000 it should be installed.
Good luck.
J
-----Original Message-----
From: Ketan Patel [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 10:30 AM
To: CF-Talk
Subject: Tool to move Access-to-MySQL
Hi All,
Does anybody know about free tools which will move Access-to-MySQL and which
will not spoil or change the data structure.
Ketan
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
