Ive been using Microsoft Access as our database but i need to upsize this to SQL Server 7.0
What is the procedure for doing this and changing the connection string so the SQL database is used.
I know this is probbably a basic question but I just don't know anything about SQL server at all. When upsizing an Access database there seems to be a few different options and i dont know which ones are right.
I am going to need to do the same procedure for some Access databases on remote servers aswell which im sure is an even more complicated subject.
Can anyone help?
What is the procedure for doing this and changing the connection string so the SQL database is used.
I know this is probbably a basic question but I just don't know anything about SQL server at all. When upsizing an Access database there seems to be a few different options and i dont know which ones are right.
I am going to need to do the same procedure for some Access databases on remote servers aswell which im sure is an even more complicated subject.
Can anyone help?
