Porting to SQL Server Express

  • Thread starter Thread starter H. Martins
  • Start date Start date
H

H. Martins

Hi.

I suppose I'm in a good timing for the transfer of a Access Database
to SQL Server Express.

Could I have some hints, please?

Thanks
Henry
 
First, what makes you think you need to update to SQL?
Second, you would use the Upsizing Wizard as you would with any version of
SQL Server.
Hint: Some of your queries will have to be rewritten because SQL syntax has
some differences between Jet SQL and SQL Server SQL
 
First, what makes you think you need to update to SQL?
Click to expand...

I suppose it hiddens the database from users. I suppose there is no
way to avoid the users do access the database file (just data).
Second, you would use the Upsizing Wizard as you would with any version of
SQL Server.
Click to expand...

Could you please point some links? I am lost, somehow.
Hint:  Some of your queries will have to be rewritten because SQL syntax has
some differences between Jet SQL and SQL Server SQL
Click to expand...

Could you also hint on this matter?

Thanks
Henry
 
There are ways to hide an Access back end. If you are using anything prior
to 2007, you can use security.

Access Help will guide you through the Wizard.

If you are not familiar with the differences in SQL versions, then you are
not ready to upsize. Chances are you don't really need to.
 
Henry said:
I suppose it hiddens the database from users. I suppose there is no
way to avoid the users do access the database file (just data).
Click to expand...

But that's not a good reason. Unless you really want to to broaden
your horizons. And that's a pretty good reason.

Other reasons would be
- increased data security
- many users
- WAN
- wireless
- an environment, such as a call centre, where you can't practically
restore the data from yesterdays backup and reenter the data.

Tony
 
H. Martins said:
I suppose I'm in a good timing for the transfer of a Access Database
to SQL Server Express.
Click to expand...

Do a search at the Knowledge Base at support.microsoft.com using the
keywords "upsizing" to review the various white papers on upsizing
Access to SQL Server as well as to ensure you have any updates
required.

Also see my Random Thoughts on SQL Server Upsizing from Microsoft
Access Tips page at
http://www.granite.ab.ca/access/sqlserverupsizing.htm

There is a tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

Tony
 
Back
Top