May 7, 2009 at 12:11 am
Hi guys,
Thanks in advance..
I do have a task which I am working right now..
we are using sql 2008, our qa server is in ........ city and development server is in another. And they both are different network, There is a db on qa which is of 4tb size and I need to create a exact type of db in development. But there is not enough space available on development to hold 4tb.. so only whole structure of qa should be moved to development but data only subset of it should be moved.
We are planning to script whole database and trying to generate it on new database in development and then move subset of data by compressing it to flatfiles. or to use data dude from visual studio..
Do we have any simple way to accomplish this task?
what is the best way that works for the situation....
Thank you..
May 7, 2009 at 12:27 am
As you are saying Development server, i do not think entire data is needed. You can scripts the database from QA and execute the same on Dev server and export the minimal data to dev server, i hope this will work out you development activity.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply