• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 552
  • Last Modified:

Access Upsize to SQL Server 2005 - Extended Property = Append Only

I'm upsizing an Access 2003 DB to SQL Server 2005.  The Upsize Wizard generated the following code.  What is the Extended Property "Append Only" all about?  Note that InsuranceCoID is the PK column.
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'AppendOnly' , N'SCHEMA',N'dbo', N'TABLE',N'tlkupInsuranceName', N'COLUMN',N'InsuranceCoID'))
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tlkupInsuranceName', @level2type=N'COLUMN',@level2name=N'InsuranceCoID'
GO

Open in new window

0
jdana
Asked:
jdana
1 Solution
 
jmoss111Commented:
You'll get better results in upsizing if you switch from the upsizing wizard to SQL Server Migration Assistant for Access.  Migration Assistant is a much better alternative that basically replaced upsizing wizard, free from Microsoft.

http://www.microsoft.com/downloads/details.aspx?FamilyId=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en
0
 
jdanaAuthor Commented:
I'll give it a shot.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now