You'll need to install the Oracle client on the server machine.

32-bit to be able to develop in SSDT and 64-bit for running the packages on the server.

Once you install the...

What's wrong with restoring a backup? It's the easiest method.

Interesting question, thanks.

Sean Lange (9/4/2013)

---

Koen Verbeeck (9/4/2013)

---

Sean Lange (9/4/2013)

---

Well this post is my 10,000th point. I guess I have proved I too can waste lots of time answering forums posts instead of...

Sean Lange (9/4/2013)

---

Well this post is my 10,000th point. I guess I have proved I too can waste lots of time answering forums posts instead of doing my actual job....

SQLSteve (9/4/2013)

---

Koen Verbeeck (9/4/2013)

---

1. You should be able to rename it. I haven't done it myself, but I saw Report databases at a client with different names.

2. You can specify...

Please do not crosspost. It wastes peoples time and fragments replies. Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1491239-7-1.aspx

Done a bit of research: not supported, but possible. In other words, don't unless you really have to.

How to Rename Your existing Report Server Database[/url]

The need for dimensional modelling typically comes when:

* you want to build a SSAS cube on top of the data warehouse (as SSAS thinks in terms of facts and dimensions).

*...

1. You should be able to rename it. I haven't done it myself, but I saw Report databases at a client with different names.

2. You can specify a service account...

Nice question, thanks.

Vedran Kesegic (9/4/2013)

---

I got the mail starting with "Congratulations!". Passing the lab exam from the first attempt and receiving so wanted MCM certificate makes me very happy! I will celebrate,...

If this is your input data

transit|Name|edcytd|Missing, defect

you'll need to add text qualifiers to the input like this:

"transit"|"Name"|"edcytd|Missing, defect"

That way, you'll be able to distinguish the last | as part of...

You can install these components using the SQL Server set-up.

Normally you don't need to restart the server.

You can install those components on the same server, but you don't need to....

GilaMonster (9/3/2013)

---

I do hope you're joking. If not, that'll be...