Name of Tables and Columns

Hi,
i just migrated an database from oracle to sql server 2005 with the migration tool from microsoft (v3). the migration tool works only with uppercase table and column names, but i need them in lower case. is there a way to modify the names of tables and columns with t-sql to lower case?
Thx
Frank
There is no "alter table ... rename " command.
I have done in following way :
1.In Management Studio select all the tables->right click->Script table as->create to->New query editor window
(all this after I eliminated some scripting setting in Tool->Options->Scripting)
2.Copy all the script
3. Paste in Word ->Format->Change case->lower case : and all the words are lower case-> select all and copy
4.Back in theStudio->paste in a new query window-> select a test db
5. Run that script
(6.Then Import Export wizard etc )|||

yes u can do this using sp_rename system stored procedure . read more in BOL

Madhu

|||

As Madhu indicated, use sp_rename.

EXECUTE sp_rename 'tablename', 'TableName', object

|||Thank you all for help, 'sp_rename' works fine.

mysql to SQL Server

Hi
I am looking to migrate mysql to SQL Server any good tool to do that
My DTS wizard doesn't give the option of mysql
Thank you,
SamuelI've used DTS against mysql - it's doable. Make sure you
have installed the drivers on your PC and the SQL Server
box. You can download mysql drivers from:
http://dev.mysql.com/downloads/
-Sue
On Mon, 22 May 2006 21:51:18 +0100, "Samuel Shulman"
<samuel.shulman@.ntlworld.com> wrote:

>Hi
>I am looking to migrate mysql to SQL Server any good tool to do that
>My DTS wizard doesn't give the option of mysql
>Thank you,
>Samuel
>|||I saw both your replies, thank you just what I needed
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:e3yQ5FefGHA.2416@.TK2MSFTNGP03.phx.gbl...
> Hi
> I am looking to migrate mysql to SQL Server any good tool to do that
> My DTS wizard doesn't give the option of mysql
> Thank you,
> Samuel
>
>

mysql to SQL Server

Hi
I am looking to migrate mysql to SQL Server any good tool to do that
My DTS wizard doesn't give the option of mysql
Thank you,
SamuelI've used DTS against MySQL - it's doable. Make sure you
have installed the drivers on your PC and the SQL Server
box. You can download MySql drivers from:
http://dev.mysql.com/downloads/
-Sue
On Mon, 22 May 2006 21:51:18 +0100, "Samuel Shulman"
<samuel.shulman@.ntlworld.com> wrote:
>Hi
>I am looking to migrate mysql to SQL Server any good tool to do that
>My DTS wizard doesn't give the option of mysql
>Thank you,
>Samuel
>|||I saw both your replies, thank you just what I needed
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:e3yQ5FefGHA.2416@.TK2MSFTNGP03.phx.gbl...
> Hi
> I am looking to migrate mysql to SQL Server any good tool to do that
> My DTS wizard doesn't give the option of mysql
> Thank you,
> Samuel
>
>

Mysql on different servers

Is it possible to connect to different databases on different servers
so i can merge them as one.

I heard there is a tool that does this but still to come accross it
any help appreciated.[posted and mailed]

kev (bairdoid@.hotmail.com) writes:
> Is it possible to connect to different databases on different servers
> so i can merge them as one.
> I heard there is a tool that does this but still to come accross it
> any help appreciated.

In MS SQL Server you would set up a linked server and use four-part notation
for your queries:

SELECT * FROM SERVER.db.dbo.tbl

But what MySQL offers, I have no idea. You need to find a forum devoted
to MySQL.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

My SSIS Presentation.

I was demonstrating some of SSIS's capabilities to our Software Development Manager and VP of IS. (We are deciding which ETL tool to use for our DW project. So goes this project goes the house).They liked what they saw and were crazy over Fuzzy lookup but commented that SSIS seems very much oriented toward the programmer side of the house. It was, maybe, not the best tool for the Business analysts who are working closely with us on this project.

Any comments on their comment?

I wonder if SSIS "data source views" (which I haven't looked at at all) address their concerns?

Barkingdog

SSIS is a programmer/developer tool. All ETL tools are programmer/developer tools.

Exactly what do they want for the business analysts? SSIS is a platform for providing the data that business analysts may use - it is NOT something to be used by business analysts themselves.

-Jamie

|||

I know the Analysts are looking for a design tool they can use to create a Logical model of the warehouse. Later on the developers will convert the logical into a physical model. Since the analysts have a great understanding of the business implications of our data they will also be the ones completing the "Description" field of each field in the Data dictionary. I guess the company is looking for one product that can do all of this. (logical modeling, data dicitonary, let analysts get involved in the process, satisfy developer needs. They seem to think that the Sunopsis product I mentioned has better coverage of all these areas.)

Barkingdog

|||

I see. I've never seen Sunopsis but would be surprised if it has a logical data modelling tool. But hey, that's good to know.

Personally I use ERWin for this sort of stuff. I like the seperation of data modelling from implementation. To me, design and implementation are different disciplines and should be treated as such. That's just my opinion of course.

In response to your earlier question DSVs are not, in my opinion, a tool for data modelling. DSVs are something you build AFTER the physical model has been implemented. And before you have the physical model you have to build the logical model.

-Jamie

|||

It's worth noting that SQL Server does have exactly the capabilities you are seeking, barking - perhaps not quite in the way you have currently thought.

Analysis Services is the market leading tool for OLAP - which is, of course, a high performance architecture for delivering business analytics to end users.

In Analysis Services it is possible to build a cube - an analytic model - in a logical mode, then generate the physical model from that. These are called top-down cubes.

See: http://msdn2.microsoft.com/en-us/library/ms174482.aspx and http://msdn2.microsoft.com/en-us/library/ms174883.aspx

hth

Donald

my sql server not listed in pull down list of 3rd party tool

hi there,
I am installing a network managing tool in a test environment that relies on
sql database. when opening the pull down list I can see all sql and msde
server from my colleagues but mine.
When introducing it manually with all credentials and domain info and hit
"test logon", it returns: "There was an error testing the windows logon
credentials. windows reports the error as Logon failure: uknown user name or
bad password. Latter are all correct.
- Why can I not see the server in the pull down menu?
- What could be the connection issue?
Dominique
1. It probably uses some flavor of SQLBrowseConnect and not
all servers are guaranteed to be listed due to network
issues, if services are running, protocols, etc. You can
find more information in the following article:
http://www.sqldev.net/misc/ListSQLSvr.htm
2. I'm not sure what tool you are using or what you mean
exactly by introducing it manually, but if windows gives you
an error of unknown user name or bad password, then you
likely have not used the correct user and password. You can
test by logging into the domain with the user name and
password. If it works and the tool doesn't, you should
contact the vendor of the network tool.
-Sue
On Mon, 31 Jan 2005 14:20:47 +0100, "ITspecialist"
<hotspare@.hotmail.com> wrote:

>hi there,
>I am installing a network managing tool in a test environment that relies on
>sql database. when opening the pull down list I can see all sql and msde
>server from my colleagues but mine.
>When introducing it manually with all credentials and domain info and hit
>"test logon", it returns: "There was an error testing the windows logon
>credentials. windows reports the error as Logon failure: uknown user name or
>bad password. Latter are all correct.
>- Why can I not see the server in the pull down menu?
>- What could be the connection issue?
>Dominique
>

my sql server not listed in pull down list of 3rd party tool

hi there,
I am installing a network managing tool in a test environment that relies on
sql database. when opening the pull down list I can see all sql and msde
server from my colleagues but mine.
When introducing it manually with all credentials and domain info and hit
"test logon", it returns: "There was an error testing the windows logon
credentials. windows reports the error as Logon failure: uknown user name or
bad password. Latter are all correct.
- Why can I not see the server in the pull down menu?
- What could be the connection issue?
Dominique1. It probably uses some flavor of SQLBrowseConnect and not
all servers are guaranteed to be listed due to network
issues, if services are running, protocols, etc. You can
find more information in the following article:
http://www.sqldev.net/misc/ListSQLSvr.htm
2. I'm not sure what tool you are using or what you mean
exactly by introducing it manually, but if windows gives you
an error of unknown user name or bad password, then you
likely have not used the correct user and password. You can
test by logging into the domain with the user name and
password. If it works and the tool doesn't, you should
contact the vendor of the network tool.
-Sue
On Mon, 31 Jan 2005 14:20:47 +0100, "ITspecialist"
<hotspare@.hotmail.com> wrote:

>hi there,
>I am installing a network managing tool in a test environment that relies o
n
>sql database. when opening the pull down list I can see all sql and msde
>server from my colleagues but mine.
>When introducing it manually with all credentials and domain info and hit
>"test logon", it returns: "There was an error testing the windows logon
>credentials. windows reports the error as Logon failure: uknown user name o
r
>bad password. Latter are all correct.
>- Why can I not see the server in the pull down menu?
>- What could be the connection issue?
>Dominique
>