Loading Stand alone Version from SQL version

jdux99

Hello All,
I'm a new user on Attain v 3.6. We are using the SQL version on our network and I have a local copy installed on my laptop. I'd like to keep my laptop data files somewhat current (weekly is fine) and would like to know the best way (if possible) to reload my laptop data/index files.
Any help would be appreciated.
Thanks, John

mstallmann

I'm not familiar with navision and SQL together, but I have a pretty good understanding of SQL Server. I would use snapshot replication. Configure the server as the publisher and your local SQL as the subscriber. When you want to update, push a subscription to your desktop using the SQL manager. This however requires you have SQL installed on both machines. I don't believe the MSDE can do replication, but I am not sure about that. Also, read up on SQL Replication to see which method of replication makes sense in your environment, as snapshot may not be the best.

Go here:

http://msdn.microsoft.com/library/en-us ... frame=true

Mike

dmccrae

MSDE can participate in replication just fine. What you'll probably need is the SQL tools to be installed along-side it, because they don't ship with MSDE.