May 16, 2009 at 6:14 am
My user data is currently stored in master.mdf.I have plan to create new user db named as TOOLS on same server then migrate the data.The user db (TOOLS) that was migrated will be backup before reinstall the SQL 2000 or rebuilt the master file.My question is can i do this way to refresh the master file ....
May 18, 2009 at 5:03 pm
You need to better explain what happened and what you are doing.
What do you mean by user data in master? What did you do to put it there? And in detail, what are you planning to do? List the steps.
May 19, 2009 at 1:50 pm
Did you create the Tables and stored procs and all other objects for the tools in Master by mistake?
-Roy
May 19, 2009 at 7:56 pm
1. I have a system which user tables was created in master.mdf in SQL server 2000.My understanding this is not good practice to create any user object in Master DB because it contains the system tables.
2. My system will be upgraded soon involving the database but using same SQL engine.However the new database schema is
different with current databases
3. I have plan to separate the user data into its own Db and will named as a TOOLS.
I plan to use DTS to migrate data between old and new database which is quite similar but having several differences in field mapping.
Could you guys suggest a better way of doing this..
My plan steps..
a) Install new instances of db under same server..
b) Create DTS to define data transformation
c) Run DTS to migrate data
d) Backup new Data
e) Fresh - Installation of new SQL Server
f) Restore the backup data
The new system need to be deployed to 100 over location
.. I might need same template for all location.
hope someone can give me advice ......
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply