MS ACCESS, MS SQL and Merge replication.
Posted on 2004-04-19
we are using MS Access database. I am in testing phase of migrating access data to sql server and replicating using merge replication with client installing MSDE and using access, adp file for the front end.
When i migrated table from ms access to ms sql four new coloums has been created and when i published database for replication on additional coloum has been created (which is rowguid, which is necessary), but i donot understand all the four coloum that has been created is really important (wheather always work like this when migrating ) or we can delete it.
Like i have a table called account with two field
When i migrate to sql server table become like this
-s_colLinege , type image
-s_Generation , type int
-s_guid , uniqueidentifier
- rowguid, uniqueidentifier
and tstamp row was also created
we were also using replication in MS Access database.
I am looking for information about these four extra coloum created. wheather its always like this when we migrate or there is some thing wronge with my migration. Can i delete those coloum or not.
If you can give me some information that will be grate.