Migrating from Access 2000 to SQL Server 2000 - Creating a SQL 2000 Server database

(Page 3 of 6 )

As a first step to migration, a database Migrate1 is created on the SQL Server, XPHTEK as shown in the next three screen shots. This is a new database from scratch, accepting the defaults.

The data file name is Migrate1_Data and its path is as shown. Since this is only a demo, the size and growth are all those of the default.

The transaction log file name, size and allowed growth are as shown, again set to the default values.

The database Migrate1 is created as shown. Presently there are only the system tables.  It has only one user, the dbo at this time. More can be added later by the dbo.

Next: Exporting tables from MS Access 2000 to SQL 2000 Server >>
 

More Microsoft Access Articles
More By Jayaram Krishnaswamy

Comments On: Migrating from Access 2000 to SQL Server 2000

· Database growth is a natural consequence of the business growth, and to meet all the...    · It looks like you are still using Access as a front-end in this scenario. Why not...    · I am not suggesting the best practice which may be, even not use Access at all. This...    · I went throught the conversion exercise using Access2003 and SQLServerExpress2005...    · Microsoft always supports for a while till the next version is in the horizon,...    · Access Project is in Data Access Pages is out in Office 2007.What do you say...   >>> Post your comment now!