and this link will guide you how to export from sql to oracle :-

http://www.mssqltips.com/sqlservertip/2011/export-sql-server-data-to-oracle-using-ssis/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=2012111

What if you create a blank file and name it as AdventureWorks2008R2_log.ldf and then try to attach the mdf and ldf file....

if you mean destination change from sql server to oracle server then I dont see any reason why you cant.

Or what alternate your can also do is :-

keep the dts/ssis...

The base query to find the number of records in a table is :-

select OBJECT_NAME(object_id) as TblName, rows as NumberofRecords from sys.partitions

where OBJECT_NAME(object_id) like 'TBL_TOC%'

Then you can further fine...

Google is best person to answer all your latest queries. Just copy paste it in google and you will get best answer.

I want to know what is the difference between partitioned table and indexed table. indexing is used for faster searching. What is the main advantage of partitioning...

I will suggest have the database based on domain specific or "common group of users" specific.

Answer is, it depends :-

1)...

what is the best way to do this? can I set up logshipping between 2 different datacenter servers? if so

what kind of things we need to set up or...

Normally, we take table backup using

SELECT * INTO new_table_name FROM old_table_name

if we do so, can we get the table backup with same old table structure (including primary & foreign...

i feel it as too much complicated when we have the import/export functionality available.

Not going to write the code, but my high level solution design for this :-

Whatever the table/s you Want to audit, create one audit table for primary table.

For ex., if...

Season Greetings and Marry Christmas to all.

Youth is when you're allowed to stay up late on New Year's Eve. Middle age is when you're forced to.

script out all the tables(only with schema) and in advanced tab, select "Script Indexes = True"

If your database have unexpected number of tables, then you can script out only required...

No. To upgrade any database to 2012 which is below 2005, you have to first upgrade the database to 2005/2008 and then only will be able to upgrade to 2012.