I want to migrate access database to sqlserver2000

[Philips]

While I am migrating database from msaccess to sqlserver2000,
s_guid,s_collineage,s_genration and s_lineage fields are inserted, as these
are not related to my database. If I remove these fields from swlserver2000
database, am i going to losing anything?

 

[John Vinson]

While I am migrating database from msaccess to sqlserver2000,
s_guid,s_collineage,s_genration and s_lineage fields are inserted, as these
are not related to my database. If I remove these fields from swlserver2000
database, am i going to losing anything?

These fields are introduced when a database is Replicated, not
(specifically) by upsizing to SQL. If you remove them you will lose
replication; it can be done but it's a bit tricky. Look up the
Replication Whitepaper on http://support.microsoft.com and follow the
instructions there.

John W. Vinson[MVP]