Posted by David Portas on 12/28/06 13:21

Igor wrote:
> Can I convert .MDB file to SQL Server database or I need to develop SQL
> server database from begin, every table, every field?

Access has an Upsizing Wizard that will port the table structures and
the data to SQL Server.

The problem is that many Access databases aren't designed for the SQL
DBMS model. So performing a simple migration isn't necessarily going to
give you a sensible or even workable solution in SQL Server. Also, the
migrated database typically may not perform well unless you redesign
some of the logic to take advantage of server-side execution and stored
procedures.

For these reasons I would recommend you view the Upsizing Wizard as
just one step in the process. You should still review the logical
design and you should probably assume that some re-design will be
necessary. Re-writing to use TSQL stored procs should also be an
essential part of the migration.

If you don't make the effort to do these things then the end result
won't be as effective as it could be. In that case you may even be
better sticking with Access until you are able to do the job properly.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

[Back to original message]