Indra77
asked on
MS ACCESS, MS SQL and Merge replication.
Hi There,
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
- assetCategoryID
-assetCategoryDescription
When i migrate to sql server table become like this
- assetCategoryID
-assetCategoryDescription
-s_colLinege , type image
-s_Generation , type int
-s_guid , uniqueidentifier
-s_lineage,type image
- 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.
Thanks.
Indra.
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
- assetCategoryID
-assetCategoryDescription
When i migrate to sql server table become like this
- assetCategoryID
-assetCategoryDescription
-s_colLinege , type image
-s_Generation , type int
-s_guid , uniqueidentifier
-s_lineage,type image
- 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.
Thanks.
Indra.
Those are the replication columns that were on the access database but hidden--they also got moved to SQL Server when you upsized.....
ASKER
As after upsizing I am going to use sql database for replication as well, so can i delete those column or i have to keep them in our database.
Thanks.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.