Can i use SSIS if I need to migrate from SQL 2000 to SQL 2005?

I thought only DTS is the solution for this because the source database is on...

Steve Fibich (9/16/2011)

---

Sunny,

Maybe I don't understand your question, are you sure you want to use BCP for migration? How about creating a backup the current version of the database...

Thanks Welsh.

Jeff Moden (9/12/2011)

---

sunny.tjk (9/12/2011)

---

sqlbuddy123 (9/11/2011)

---

Jeff got it perfectly right. Just use CREATE Table and add an identity column to it.

...

sqlbuddy123 (9/11/2011)

---

Jeff got it perfectly right. Just use CREATE Table and add an identity column to it.

...

sqlbuddy123 (9/11/2011)

---

Jeff got it perfectly right. Just use CREATE Table and add an identity column to it.

...

Welsh Corgi (9/8/2011)

---

Depending upon what you are doing you could partition the table(s) are perform a Merge Split.

http://blogs.msdn.com/b/felixmar/archive/2011/02/14/partitioning-amp-archiving-tables-in-sql-server-part-1-the-basics.aspx

http://blogs.msdn.com/b/felixmar/archive/2011/08/29/partitioning-amp-archiving-tables-in-sql-server-part-2-split-merge-and-switch-partitions.aspx

I did this a few times when this was not an option but...

sqlbuddy123 (9/11/2011)

---

Create a second table on the primary server with identity column so that each record can be uniquely identified and then start the insert in batches 10000 at a...

GilaMonster (8/26/2011)

---

So ask someone who has rights to run it

No, the...

Sorry, I just have read permissions to the database.

No, the database hasn't been upgraded yet.

Both Clustered and Non clustured.

Jeff Moden (8/23/2011)

---

Why not write a view and submit it to the folks asking you to do the job so they can...

My read permissions won't let me do that.

Would it be possible to write a query to push the results of sp_spaceused into a temp table? If yes, can someone...

Forgot to ask one last question:

Is it necessary to run any kind of maintenance jobs on static databases? These static databases will not be marked read-only.

That answers my question. Thanks Gail.