Assume you have got Northwind database with 2 tables Customers, Ord'ers and relationship between them on Custo'merID column in both tables.
You should remove (') and (") from table/field names before upsizing to SQL Server database.
Single quote (') will force Microsoft Upsizing Wizard (MUW) 2002 to fall over if any table is named with such a character and MUW 2000 to fall over if any table and fields are named with such a character.
Double quote (") will force MUW 2002 to rename any table (field) from Custo"mers to Custo_mers (field Custo"merID to Custo_merID) but any relationships on the field Custo_merID will not be created because the field was renamed.<br>
MUW 2000 will fall over displaying an error message:<br>
Server Error 170: Line 5: Incorrect syntax near 'ers_FK00'.
Server Error 103: The identifier that starts with '
FOREIGN KEY (CustomerID) REFERENCES Custo_mers(Customer_ID) ,
EmployeeID int ,
OrderDate datetime ,
RequiredDa' is too long. Maximum length is 128.
Server Error 105: Unclosed quotation mark before the character string '
PRIMARY KEY NONCLUSTERED
(OrderID)
)'.
For more information about SQL Server Naming convention see <a href="http://www.ssw.com.au/ssw/kb/KB.asp?KBID=Q316015">http://www.ssw.com.au/ssw/kb/KB.asp?KBID=Q316015</a>
There are 3rd party utilities on the market ‘Find & Replace’ – www.rickworld.com and others http://www.ssw.com.au/ssw/standards/developergeneral/TheBest3rdPartyTools1.aspx#FindAndReplace