SQL Server licenses

Question

SQL Server licenses

amedina

Newbie

Points: 2
More actions
April 30, 2003 at 9:41 am

#81475

I have to migrate an Access 2000 database to SQL Server and I have several questions.
I have also two front ends accessing the Access DB. The migration does not seem a problem, as SQL Server offers the tools to do it.
Would I need to make any changes in the front ends or they should work like they did before the migration?
Which SQL server licenses would I need?
Many Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

mimorr SSCarpal Tunnel Points: 4850 More actions · Answer 1

They should work normally as long as you don't change datatypes, fieldnames or tablenames when you upsize to SQL. What is prompting your move?

If you are only going to have one SQL Server, then that SQL will need CALS for all the people who need to connect. Microsoft changed all their licensing recently so you will want to check and verify compliance.

We have had some problems changing from Access to SQL back-ends. Mostly it was because Access interprets SQL's bigint, decimal, bit fields differently.

Michelle

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 2

Agreeed with Michelle. Also want to add therer something you should do after migration, for example, move the queries into SQL Server as stored procedures, optimize queries and indexes tuning, the table's property that were in Access may have to be recreated in your SQL server tables.

You may also consider to pay SQL Server license by number of processors that will allow unlimited users to connect to SQL Server.

dgermundson Hall of Fame Points: 3175 More actions · Answer 3

The front end will have to change in that you will have to specify a new connection string to the SQL Server. That is if you are using ADO. If you use ODBC, then just change the System DSN. As long as your queries don't use Access specific notation then everything else can stay the same.

Darren

amedina Newbie Points: 2 More actions · Answer 4

Thanks to all for your help.

The reason for the migration is basically the size of the DB, as the company is growing in terms of employees (double). I have not seen the code (I did not write any of it), and I don't know how the front end connect to the database (ADO or ODBC). At the moment I am just researching how much would be the cost of migrating.

Again, many thanks.