InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 09:59:19 GMT20http://www.sqlservercentral.com/Forums/Topic689652-146-1.aspxit will copy all objects (including constraints, PS, function etc, whatever valid for SQL server), at least its true for SQL server to SQL server. I dont know how it will behave with oracle.Fri, 03 Apr 2009 09:14:15 GMTBoolean_zhttp://www.sqlservercentral.com/Forums/Topic689652-146-1.aspxThanks lots sir,Sir if i use DTS Import/export utility what happen with constrains (like pk,fk) and can i import Proc also.siva.Fri, 03 Apr 2009 03:11:21 GMTsivavella.kumarhttp://www.sqlservercentral.com/Forums/Topic689652-146-1.aspx1. Create a new database (as schema in oracle is like database in sql, database in oracle is like server instance in sql ) 2. You can use DTS Import Export Wizard (Start > All Programs > Microsoft Sql server > Import Export Data) to import all objects As your are new to sql server, please read some articles related to using dts import export wizard. Fri, 03 Apr 2009 02:59:09 GMTBoolean_zhttp://www.sqlservercentral.com/Forums/Topic689652-146-1.aspxHi experts ,I m oracle DBA! in oracle we have 'ora' schema that 'ora' schema i what to export it and i what to import into newly installed MS SQL SERVER 2000 (for test per), experts i don't have any idea abt sql server 2000. this is one of our client requirement.Experts give me what format i what to export the schema and how to import into the MS SQL SERVER 2000. or any other way is there for same?Thanks Advsiva.Fri, 03 Apr 2009 02:40:43 GMTsivavella.kumar