Greetings all,
I'm basically looking for guidance in taking an existing db from an ISP, backing up to my local server, and creating a new identical db on the same ISP (different db and user however). (The client is creating a brand new site that will be only slightly different than the original.)
I'm more used to using postgresql on linux and being able to run scripts to do everything. With enterprise manager on the isp it's a bit different.
Approach:
I use dts to get all objects and data from site 1 to a database on my local server. Should I use the "copy database users/roles" option? In any case I have managed to get all objects; at this point they are owned by the site 1 user (from the ISP). I can't at this point upload from my local db to the new site since that user can't use site 2's db. Do I need to create an identical user to that provided by the ISP (for the second site) and change ownership of all the tables/views to that new user?
I know this is probably a simple thing, I'm a bit frazzled with the project at this point and would appreciate any help.
Thanks,
Rick
I'm basically looking for guidance in taking an existing db from an ISP, backing up to my local server, and creating a new identical db on the same ISP (different db and user however). (The client is creating a brand new site that will be only slightly different than the original.)
I'm more used to using postgresql on linux and being able to run scripts to do everything. With enterprise manager on the isp it's a bit different.
Approach:
I use dts to get all objects and data from site 1 to a database on my local server. Should I use the "copy database users/roles" option? In any case I have managed to get all objects; at this point they are owned by the site 1 user (from the ISP). I can't at this point upload from my local db to the new site since that user can't use site 2's db. Do I need to create an identical user to that provided by the ISP (for the second site) and change ownership of all the tables/views to that new user?
I know this is probably a simple thing, I'm a bit frazzled with the project at this point and would appreciate any help.
Thanks,
Rick
