Development & Lives databases

Hello all, apologies if i've posted this in the wrong forum!
I have 2 databases development and live. Development has the correct
structure (SP's and tables) and live has the correct data. I would like to
make live match the development database but not to loose any data. Is
replication the best method?
If so, any simple www's that could help me?
Thanks all,
Jon
you have to pick an authority. Sounds like you have to ensure that live has
the correct schema, and then push your live data to development.
Transactional replication is ideal for this. It does require that every
table has a pk though, which it should.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jon" <Jon@.discussions.microsoft.com> wrote in message
news:128F3236-EBD2-4034-8A3A-A72248CD3011@.microsoft.com...
> Hello all, apologies if i've posted this in the wrong forum!
> I have 2 databases development and live. Development has the correct
> structure (SP's and tables) and live has the correct data. I would like to
> make live match the development database but not to loose any data. Is
> replication the best method?
> If so, any simple www's that could help me?
> Thanks all,
> Jon

Developer edition versions

My apologies if this is the wrong newsgroup.
In the UK i have been hunting for a copy of SQL Server 2005 Developer. The
problem i have is that i can only source the 64 bit version and the
specifications on the various suppliers site states it will only work with a
64 bit OS.
Could anyone help me by pointing out if there is a 32 bit version and if
they know where I can find a copy?
I did try the MS shop which appears to offer a 32/64 bit version but they
don't ship to the UK and they customer support email was a waste of time.
Thanks.Hi Matt,
I stumbled upon this site in the UK.
http://www.saversoftware.co.uk/details-918.htm
Check it out
Hope this helps
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200609/1

Developer edition versions

My apologies if this is the wrong newsgroup.
In the UK i have been hunting for a copy of SQL Server 2005 Developer. The
problem i have is that i can only source the 64 bit version and the
specifications on the various suppliers site states it will only work with a
64 bit OS.
Could anyone help me by pointing out if there is a 32 bit version and if
they know where I can find a copy?
I did try the MS shop which appears to offer a 32/64 bit version but they
don't ship to the UK and they customer support email was a waste of time.
Thanks.
Hi Matt,
I stumbled upon this site in the UK.
http://www.saversoftware.co.uk/details-918.htm
Check it out
Hope this helps
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200609/1

Developer edition versions

My apologies if this is the wrong newsgroup.
In the UK i have been hunting for a copy of SQL Server 2005 Developer. The
problem i have is that i can only source the 64 bit version and the
specifications on the various suppliers site states it will only work with a
64 bit OS.
Could anyone help me by pointing out if there is a 32 bit version and if
they know where I can find a copy?
I did try the MS shop which appears to offer a 32/64 bit version but they
don't ship to the UK and they customer support email was a waste of time.
Thanks.Hi Matt,
I stumbled upon this site in the UK.
http://www.saversoftware.co.uk/details-918.htm
Check it out :)
Hope this helps :)
--
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.db2india.org
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200609/1