June 17, 2009 at 6:26 am
I'm in the process of moving objects (6000+) from multiple databases into one and carved up using schemas. I've looked at a few different methods and i can't see a simple solution and was hoping someone could provide some guidance???
I've looked at SSIS which i thought was idea for the transfer of objects but as far as i can see i cannot transfer it to a new schema in a different database which would mean a 2 stage process of moving the object to the new database then altering the schema of it. I've looked at using DMO to create the script for the objects (altering it for the new schema) and inserting the data into this new object which would involve manual intervention. I've also thought about going the simple route of a simple "select * into newDB.newschema.newobject" but this gives the issue of not having the relevant identity columns or PK's.
surely someone somewhere has done this before and i'm missing a trick here....? Any help greatly appreciated
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply