November 30, 2006 at 3:15 pm
For purposes of doing development work on the next version of our applications, which will be running against SQL 2005, I want to periodically move data from our current 2000 database to the 2005 database. I don't need transactional replication, just periodic snapshots. I am setting up the 2000 as the publisher. The distributor and the subscriber are on the 2005. And I have set up a snapshot replication.
It works fine.. but I want to transform the text fields in 2000 into (n)varchar max fields in 2005 (and possibly create some other minor structural changes).. I don't see where this can be done in the replication process. Is there something I'm missing? Is there a third party product that would do it? Or do I just need to script the changes and apply them to the 2005 database after every snapshot replication?
Thanks
November 30, 2006 at 10:45 pm
You can only do that with replication going from 2005 to 2000. SQL 2000 doesn't know about the new datatypes, so it can't transform the data types. SQL 2005 still supports these data types anyway so there is no requirement to change them (though doing so would be a good thing).
December 1, 2006 at 6:44 pm
Thanks.. I was hoping that there is something that could be done on the receiving end (the 2005 end).. but I suppose I can always just run a script to change the datatypes after the data has been moved over..
December 1, 2006 at 6:49 pm
I'd be surprised if someone hasn't already written and posted that script somewhere. I would check Google first.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply