Im guessing this is the right forum for this question:
I have a database on a WS2003 box running on MSDE 2000. Were trialling SQL 2005 (currently running on Win XP pro) so what i would like to do is to "copy" the database from the WS2003 box to the XP SQL box. So we can evaluate the database and see what SQL does/doesnt do.
1. How can this be done please?
2. Will it do anything to the original database?
3. Can this be scheduled to be done everyday? if yes how please?
Thank you in advance.
If you want to do a one-time copy, just create a database backup and restore it to your new server.
If you want to do daily refreshes where the data is refreshed from scratch (meaning tables dropped/re-created), then you can set up snapshot replication.
if you want to do a one time setup and then have incremental changes flowing to your new server in near-time latency, then you can set up transactional replication.
You can read more about replication in Books Online.
|||Thanks Greg for your answer. Im sure replication is what i need to read on but i was hoping for more of a direct approach i.e. Go to File > Export........ i did read books online but theres a lot of content and all im after is a quick approach to see if this is what im after or not or even a demonstration of how it can be done would suffice. I know i cant master it just like that but a bit of trial and error maybe needed just before reading pages of info. Maybe a link to read on MSDE 2000 as this is the free version where im having difficultiesin setting up rep.
I know how to backup and restore so if i can build on that that maybe helpful.
Just trying to save time and when i know the basic approach ill know where to look within books online.
Thanks
|||Unfortunately MSDE cannot be used as a publisher/distributor for snapshot or transactional replication, if you want to test around with replication then you should install the developer version. Plus I would move to SQL 2005 instead of SQL 2000. Once you install the developer version, you can use the wizards to set things up. However I would strongly recommend reading Replication topics to get a better understanding of what your needs require, it will help determine what options you want to enable/use.
No comments:
Post a Comment