Re: Upsizing from Access doubles varchar columns

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 02/18/05 

Date: 18 Feb 2005 05:14:25 -0800

If you don't need unicode columns then change them all to non-unicode
(VARCHAR, CHAR, TEXT). This is trickier than it sounds because indexes
on those columns have to be recreated - not difficult for one or two
columns, harder if there are many dependent objects. If you are still
in development and happy to drop and recreate everything then the
easiest way is probably be to generate a table creation script (All
Tasks > Generate Script in Enterprise Manager), search and replace all
the references to NVARCHAR, NCHAR and NTEXT then re-run the script.
Take a backup before you do this please! Obviously you'll have to
recreate any data but you will hopefully have mechanisms to do that
anyway in development.

I'm not a fan of Upsizing Wizards. It is unwise to assume that a schema
design in Access will also be appropriate for SQL Server. The best way
is to review what you have and redesign where necessary. 

--
David Portas
SQL Server MVP
--

Relevant Pages

  • Re: Upsizing from Access doubles varchar columns
    ... 32 Ridley Road ... > in development and happy to drop and recreate everything then the ... > Tasks> Generate Script in Enterprise Manager), ... > design in Access will also be appropriate for SQL Server. ...
    (microsoft.public.sqlserver.programming)
  • Re: Delete table data
    ... It might be best to script out all the objects, drop the db and recreate it ... Just make sure to have a backup and make sure you script out all the ... > Is there any easy way to clear all table data for a SQL server database? ...
    (microsoft.public.sqlserver.setup)
  • Re: sp_dropmergearticle
    ... I'd script out the publication then drop it. ... Edit the script to not have the ... article in it then recreate. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • How to generate script from SQL 6.5 scheduled tasks
    ... Is there a way or any script to generate the script for ... scheduled tasks on SQL Server 6.5? ... script to recreate the tasks. ...
    (microsoft.public.sqlserver.server)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)