Solved

MS ACCESS, MS SQL and Merge replication.

Posted on 2004-04-19
3
311 Views
Last Modified: 2008-02-26
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.
0
Comment
Question by:Indra77
  • 2
3 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 10864013
Those are the replication columns that were on the access database but hidden--they also got moved to SQL Server when you upsized.....
0
 

Author Comment

by:Indra77
ID: 10932663
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.
0
 
LVL 34

Accepted Solution

by:
arbert earned 50 total points
ID: 10935628
You can delete them since they were the previous Access replication columns....

Brett
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now