March 3, 2006 at 2:02 pm
Good day.. I have a dev database with dummy data in which I was hoping to export just the structures and permissions so that I could start with a blank "template". What is hte best way to do this? Then once that is done i will need to import data from an older version of the database that has a slightly different table format (new features added to the system, etc). That way the production data is added to the new database at which time a data entry person will be inputting the missing data for the new fields/tables.
Thanks in advance,
March 3, 2006 at 2:51 pm
You can use the generate sql script wizard from SQL 2k.
Alternately, you can delete all the dummy data and backup and restore the database. You will need to resync any users and also reseed identity fields if you are using any.
For importing the data you can use DTS transformations.
March 6, 2006 at 9:07 am
You can also use the Import/Export wizard to copy the structure and permissions. Use the third option, "Copy objects and data between SQL Server databases". Check the "Create destination objects" box and uncheck the "Copy data" box.
Greg
Greg
March 6, 2006 at 12:24 pm
select * from Table1 Insert into Table2 where 1=2
OR
CREATE TABLE student2 SELECT * FROM student WHERE 1=2
March 6, 2006 at 1:20 pm
Good day - I was trying this proceedure and ran into an issue.
In the middle of the export I got the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.MSDM_Import'.
Ideas?
March 6, 2006 at 2:01 pm
Is MSDM_Import an object in your source database?
Greg
Greg
March 6, 2006 at 2:40 pm
yes it is, but I am just not sure what the issue is with the name..... I never had any kind of error when i created it.
March 7, 2006 at 2:02 pm
The message means that the table doesn't exist. Is it owned by someone other than the database owner?
Greg
Greg
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply