Batzal
asked on
HOW TO EXPORT DATA AS OBJECT IN SQL SERVER 2005 ??
I want to export data from SQL SERVER 2005 to another SQL SERVER , as OBJECT ( with indexes, primary keys, not only data) , i was using SQL SERVER 2000, and when i go to import/export it shows me if i want to export as object , this option in SQL SERVER 2005 exists ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Mark, if i used the SQL 2000 some days to export as object, the only way in 2005 is to generate the script to create table , create index and then insert , if this is the way SQL 2005 is worst than SQL 2000.
This is ok ?? or im wrong ??
This is ok ?? or im wrong ??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I expect to be a easy solution to do it.
If somebody knows , please tell me.