Merge two databases (SQL & Access) Problem?

Question

Well, I've two databases the first one is access & the second one is SQL & they hold the same data
they have the same tables, but at the Access data base I've a column which data type is auto-number
& every time I add new record in the access DB I've to copy it to the SQL DB because SQL don't have auto number data type

How I can get rid of the access database and depend only on the SQL DB without any data loss, and how to come over the auto number problem ?

Answer 1

SQL Server has the IDENTITY keyword which basically does the same thing as autoincrement in Access.

Answer 2

You can set the field to integer in SQL and then auto increment the type so it will create an incremental number assigned to the field. This can be done in MySQL pretty easily.

Answer 3

SQL is not a database system, it is a language. Are you talking about SQL Server? if so, it does have an auto number, its called an identity field.



When asking questions, please be specific, as SQL DB is not SQL Server, nor Oracle.