Is it possible to replicate Access DB with SQL Server? -- sql server replication

Vasily Sokolov
7/30/2007 2:58:01 AM

Hello, Paul!

Thank you for this answer but does it mean that we don't have comprehensive
compatibiility with SQL 2000 within SQL 2005? I definitely have link to the
description of process setting replication with Access DB for SQL 2000! And
in this description some steps are containing simply T-SQL instructions which
I can try also in SQL 2005. How do you think is it useful test this approach
in SQL 2005 or is it only wasting time?
Thank you for the clarification in advance.

Vasily Sokolov

[quoted text, click to view]

Vasily Sokolov
7/30/2007 4:06:00 AM

Here is the post from you which is explaining that it is possible make
replication with Access however the exact version of SQL server is not
mentioned:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?pg=17&cat=en_US_5393cc52-836c-4327-8044-f463a923aeac&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.replication&fltr=

[quoted text, click to view]

Paul Ibison
7/30/2007 9:34:01 AM

Yeah - the book I'm referring to here is Hilary's book, which is written for
SQL Server 2000, so the version I was referring to is kind of implied.
Actaully, the poster didn't mention the version of SQL Server so this was a
big guess - I think the Access 2000 reference made me go down this route of
thinking!. Anyway, according to TechNet, Access as a subscriber has been
discontinued in SQL Server 2005:
http://technet.microsoft.com/en-us/library/ms143723.aspx
Cheers,

Vasily Sokolov
7/30/2007 9:46:02 AM

Paul,

Thank you for this link - it is extremely useful. As I understand we don't
have nowadays "light" alternatives for the replication between SQL Server
2005 and file with data (similar to Access). I mean that it is rather
valuable quality when you can have simple file which can be placed to Flash
card and you don't need over- complicated detach/attach process in order to
setup it at any PC and use Replication on-demand. Do you know about the
alternative from Microsoft?

Vasily Sokolov

[quoted text, click to view]

Paul Ibison
8/9/2007 10:50:13 PM

Not replicationwise. You might consider using something like SSIS for data
transfer instead?
Cheers,
Paul Ibison

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Is it possible to replicate Access DB with SQL Server?