Converting MS ACCESS DATABASE TO SQL DATABASE.
Posted on 2004-03-22
I need few more information on this topic for converting the access db to ms sql db.
When i went through the information on using upzing tool and DTS in sql server, i found few different option available, which make me confuse.
I used MS ACCESS upsizing tool to convert only table defination and structure, relation ship etc,
and DTS in sql server to import data in existing database created with upsizing tool.
below is the few information i need.
- should i use trigger or DRI for table relationship
-should i use upsing tool for complet importing of table defination as well as data or upzing only for table defination, relationship and DTS for data.
-when converting application there are three option,
1.- no application change
2. Link sql server table to existing application
3. create a new access client/server application
keeping in mine that we want to use our existing front end after moving to sql server.
after i move data what and how i can use the exising front end, as i have not done this before, i really need information.
i already move data to the sql server, but this is only testing database. please give me brief information how can i move, configure to use existing front end.
Converting MS Access database to the SQL...