synchronize Sql Server DB to XP notebook

  • Thread starter Thread starter DraguVaso
  • Start date Start date
D

DraguVaso

Hi,

My apologize if I kind of crosspost this, but I don't know if I should
search my solution in the direction of Sql Server or XP.

I have on my Windows XP Notebook an SQL SERVER 2000 installed, just like on
my Server. I am normally logged in to the domain, so I develop with the SQL
Server on the server. But when I'm at home, I want to develop to the local
Sql Server on the notebook because I don't have any connection anymore with
the server.

Is there a way to have always the latest version of the Sql Server database
copied on my notebook? Via the synchronization of XP, via replication of Sql
Server? Simply copying the mdf-files to my notebook (the Sql Server on my
notebook isn't started when I don't need it to gain on resources)? I really
would like a nice solution, that gives me the uptodate data, but also
table-structure (new added tables, changes to tables etc) of the Sql Server.

Any help would be really appreciated!

Thanks a lot in advance,

Pieter
 
Hi

Make a backup on your primary SQL Server, then restore it to your laptop.

To update your primary server again, script your changes as you make them
and then run them against your primary DB again (of course after you have
tested it against your test server, because you don't want to destroy your
production db by mistake).

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: (e-mail address removed)

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/
 
That's indeed a possibility, but it's not really a 'nice' one. I was more
looking for something that does it all automaticly.
Could something like this be possible with an Sql Job on my server that
restore's every day the backup to my notebook-database?

the key-points I am looking for are:
- it has to happen automaticly (but bat-files and tasks etc are automaticly
enough for me)
- it should be possibly to work without my Sql Server on my notebook running
(to gain on ressources when developping)
- the direction notebook -> server isn't really needed
 
Since you've shot down Mike's suggestion, my I suggest you post this in many
of the SQL newsgroups, and you'll most likely get many other suggestions.
Just remember, you most assuredly have either SQL Standard/Enterprise on
your production server at work, and your XP installation is most likely
running SQL Developer, which in most cases won't make a difference, unless
your production system runs multiple instances, where SQL Developer is
limited to one instance.
 
DraguVaso said:
That's indeed a possibility, but it's not really a 'nice' one. I was more
looking for something that does it all automaticly.
Could something like this be possible with an Sql Job on my server that
restore's every day the backup to my notebook-database?

the key-points I am looking for are:
- it has to happen automaticly (but bat-files and tasks etc are automaticly
enough for me)
- it should be possibly to work without my Sql Server on my notebook running
(to gain on ressources when developping)
- the direction notebook -> server isn't really needed
Click to expand...
What do you expect - some kind of a magic feature that can read your
mind and on it's own find out what you want to get on your laptop?...:-).
I think you're left with Mike suggestion - there aren't really any smart
way that can transfer things across. You can create a job that is
schedules to restore the latest production backup on your laptop every
morning, but that will require SQL server service to run on your laptop
(...and if that's a problem you should get a better laptop..). This will
of course overwrite your existing database. If you want to transfer only
changes, you could maybe look at tools like SQLCOmpare to compare your
databases and then script out the changes - but I doubt that will be so
simple that it can just run automatically in the background.

Regards
Steen
 
Back
Top