export import table structures

Question

export import table structures

Viewing 7 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 1

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.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 2

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

Brenda Lowe-306127 SSC Enthusiast Points: 101 More actions · Answer 3

select * from Table1 Insert into Table2 where 1=2

OR

CREATE TABLE student2 SELECT * FROM student WHERE 1=2

Dustin Krysak SSC Rookie Points: 45 More actions · Answer 4

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?

Greg Charles SSC-Forever Points: 45403 More actions · Answer 5

Is MSDM_Import an object in your source database?

Greg

Dustin Krysak SSC Rookie Points: 45 More actions · Answer 6

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.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 7

The message means that the table doesn't exist. Is it owned by someone other than the database owner?

Greg