IBM Universe Database

My company has an IBM Universe database that i would like to connect to via SSIS. Is this possible? If so, please point me in the right direction. I managed to find the U2 tools on the IBM website but i am a bit confused as to what i need to do.

Thanks

In order to load data to/from other data sources into SSIS, you'd need OleDB, ADO.NET or ODBC (supported via the .NET-ODBC bridge) connectors. Microsoft doesn't have a connector for UniVerse, but have you checked with IBM or its vendors?

|||IBM has ADO.NET Provider called "IBM Data Server Provider for .NET" and "IBM Database Add-ins".

Please try the above product.

Please read this article
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0711kumar/

I want source control for SQL Server 2000...

Hi guys'n'girls...

I currently work for a company where we develop several large ASP.NET applications which are VERY data centric. But lately we have run into a problem on our developer DB...

On the project I am working on we currenctly have approx. 10 developers working concurrently on the database. That means that we often run into errors caused by two developers working on the same stored procedure, function or trigger so the developer who adds his changes last, overwrites the modifications done by the other developer. The obvious answer is source control for the db, but as far as I can tell this is only available for stored procedures and not for functions or triggers... And even the stored procedure solution isn't very safe because it only works if every developer is editing the procedures through VS.

So what do we do? There must be some solution to this problem... And I'm pretty convinced that we are not the first company to face this problem. Are we doing it the wrong way or do you know another solution?

Thanks in advance!

Try these two urls for options but the manual way to do it is to leave the DDL coding to one or two developers working together and run a stored proc to eliminate duplicates. Hope this helps.

http://www.allisonfamily.org/bill/library/articles/vss-sql-howto/

http://www.sqlservercentral.com/products/bwunder/archiveutility/

I really need some advice.

Hi

Dont laugh but...

I am not entirely ignorant to web technologies, and best practices but i am having a bit of a planning dylema.

My company has a well established SQL 2000 database with windows application which has been created by myself, what i am planning on doing is creating a web site, using asp.net and publishing some of the information, so that our clients may use it, and stop pestering us on the phone. what i would like to know is what would be the best way forward, obviously i don't want to show them all our information, and don't want to put 5Gb worth of data onto a ISP website. What would you suggest i do?

Thanks in advance

BradHow important is it that the data be real-time?

You might consider implementing some DTS packages that extract key pieces of data that you want to share with your clients. The DTS package would write to a database on a separate server.

Terri

I never post my problems but I have no time right now

I just released a beta and I am too busy with the testers right now.

New company. Brought into automate the back office and to advise on the design on their software. Lots of sloppiness here. Denormalized tables, inline SQL all of the usual crap I get paid to cleanup.

I have'nt gotten to this part of there process yet but they do some over night processing that can take up to 12 hours. (I can't wait to look at this code).

Data entry people get here at 6 am and their applications can't seem to connect to the SQL Server but the processing has stopped. They just hang and hang. The network guy comes in about 8 am and restarts the SQL Service Fonzi style and everything is fine. The DBA thinks it's a network issue which seems a tid bit ridiculous to me since restarting the service "fixes" it.

I suspecting it's a memory issue.

Any ideas on where to start.since you're one of the good guys i will ask you if you have a preference for what to rename the subject line of your question to, since the current subject is too nebulous|||on the other hand, it is fairly distinctive so i may just leave it

:) :) :)|||rename constipated SQL Server|||Log on to the SQL server, and see what is going on in Task Manager, first. You have probably already done that, but it does sound like a resource problem somewhere (memory, CPU, etc.). Can we hope this is SQL 2000? Or are you stuck with 6.5?

If there are no resource problems, and the operating system is running smoothly, you probably have some sort of open transaction hanging everyone up. The data entry application may have commandtimeout set to "0", which sounds about in line with what you describe of their code.|||My bet is on SQL object locking. I'd check sp_who (definitely not sp_who2 until I knew it was safe) before rebooting to see if a spid is blocking the rest of the known universe.

The lovely little nightly process might be camping on some resource that everybody needs to "wake up the daemons" in the morning. When you kick the ground out from under it (by restarting SQL), the locks are gone and life is lovely once again.

-PatP|||Yes it is SQL 2K.

Thanks guys. I will let you know the resolution. Of course I will have to come in at 6 am. No VPN here. Small shop.

Have a good weekend.|||How long does the "fix" take after it's restarted?

Are the files set to autogrow?

Is the log being blown out?

How do you know if the 12 hour batch windows actually completes.

Is there enough space left on the drives?

Are there any other services on the box that are in competition for the memory?

If there are, my first reccomendation would be to isolate|||Thanks. I will know more on Monday. I just have'nt had much time to think about this due to the revamp project from hell. I plan on being here early to gauge what is going on.

===========================================
How long does the "fix" take after it's restarted?

Immediate

Are the files set to autogrow?

Yes

Is the log being blown out?

Not sure I would have to check the log size before and after.

How do you know if the 12 hour batch windows actually completes.

They tell me so when I ask.

Is there enough space left on the drives?

Yes

Are there any other services on the box that are in competition for the memory?

This box is dedicated the SQL Server.

If there are, my first reccomendation would be to isolate|||My bet: uncommitted transactions in the nightly process.

I need your migration stories!

Greetings:
I'm a lowly applications programmer (one of three IT employees total) in a
company that's about 40 personnel strong in management and 50 personnel
strong in production.
We have a shared drive that has about 81 Access databases in it (total of
1.25 Gigs of information) that have been made since Access 2.0 was available
all chucked full of custom software mostly using DAO for data access. All of
them are in Access 97 format. It's just a huge blob of interconnected
databases and my opinion is it's time for them to go!
So, I'm looking for migration stories. I know there are others out there who
have been in this situation and I'm wondering if you can comment a little
about your particular scenario. Was it cost effective in the end, was it
worth the hassle, tips & tricks, and how you finally managed to win your
management over to the idea of shilling out the dollars for a real DBMS.
Thanks!
CaseyThis is a multi-part message in MIME format.
--=_NextPart_000_036F_01C3DB74.FFF6CEC0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit
You may want to check out Russell Sinclair's book:
http://www.apress.com/book/bookDisplay.html?bID=74
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Casey" <clengacher@.smcky.com> wrote in message
news:e5i2W352DHA.1736@.TK2MSFTNGP09.phx.gbl...
Greetings:
I'm a lowly applications programmer (one of three IT employees total) in a
company that's about 40 personnel strong in management and 50 personnel
strong in production.
We have a shared drive that has about 81 Access databases in it (total of
1.25 Gigs of information) that have been made since Access 2.0 was available
all chucked full of custom software mostly using DAO for data access. All of
them are in Access 97 format. It's just a huge blob of interconnected
databases and my opinion is it's time for them to go!
So, I'm looking for migration stories. I know there are others out there who
have been in this situation and I'm wondering if you can comment a little
about your particular scenario. Was it cost effective in the end, was it
worth the hassle, tips & tricks, and how you finally managed to win your
management over to the idea of shilling out the dollars for a real DBMS.
Thanks!
Casey
--=_NextPart_000_036F_01C3DB74.FFF6CEC0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

You may want to check out Russell =Sinclair's book:
http://www.apress.com/book/bookDisplay.html?bID=3D74">http://www.=apress.com/book/bookDisplay.html?bID=3D74
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Casey" wrote =in message news:e5i2W352DHA.1736=@.TK2MSFTNGP09.phx.gbl...Greetings:I'm a lowly applications programmer (one of three IT employees total) in acompany that's about 40 personnel strong in management and 50 personnelstrong in production.We have a shared drive that =has about 81 Access databases in it (total of1.25 Gigs of information) that =have been made since Access 2.0 was availableall chucked full of custom =software mostly using DAO for data access. All ofthem are in Access 97 =format. It's just a huge blob of interconnecteddatabases and my opinion is it's =time for them to go!So, I'm looking for migration stories. I know there =are others out there whohave been in this situation and I'm wondering if =you can comment a littleabout your particular scenario. Was it cost =effective in the end, was itworth the hassle, tips & tricks, and how you finally =managed to win yourmanagement over to the idea of shilling out the dollars =for a real DBMS.Thanks!Casey

---

--=_NextPart_000_036F_01C3DB74.FFF6CEC0--|||Management only hears the sound of money. Any changes you suggest must have
some impact on general productivity of the company or IT management costs.
Simplistically, if you can demonstrate that spending $20,000 on hardware and
$30,000 on development will increase productivity of 90 employees by 5%,
then there is a direct connection in the management's mind to the bottom
line and your suggested changes. If all you do is make snarky comments about
the in-efficiency of the system, then nobody will hear you. So you really
need to create a solid, justifiable business case for what you think is
obvious.
One approach is to break the problem into small enough chunks that
management is able to tolerate the risk. If you tell them you want to
consolidate the entire 81 databases into an integrated, seamless
productivity solution, it might scare the hell out of them and they'll shut
you down with little deliberation. But if you suggest a smaller prototype
project that takes a few of these databases and makes them more effecient,
then you have a proof-of-concept that can be applied to the whole mess. Once
you demonstrate some success, then the rest is easier to sell.
As an aside, I can't imagine any logical reason for 81 different databases
to manage an organization that size.And in Access, no less.
Oy!
Good luck, lowly applications programmer :)
Bob Castleman
SuccessWare Software
"Casey" <clengacher@.smcky.com> wrote in message
news:e5i2W352DHA.1736@.TK2MSFTNGP09.phx.gbl...
> Greetings:
> I'm a lowly applications programmer (one of three IT employees total) in a
> company that's about 40 personnel strong in management and 50 personnel
> strong in production.
> We have a shared drive that has about 81 Access databases in it (total of
> 1.25 Gigs of information) that have been made since Access 2.0 was
available
> all chucked full of custom software mostly using DAO for data access. All
of
> them are in Access 97 format. It's just a huge blob of interconnected
> databases and my opinion is it's time for them to go!
> So, I'm looking for migration stories. I know there are others out there
who
> have been in this situation and I'm wondering if you can comment a little
> about your particular scenario. Was it cost effective in the end, was it
> worth the hassle, tips & tricks, and how you finally managed to win your
> management over to the idea of shilling out the dollars for a real DBMS.
> Thanks!
> Casey
>

I need some advice before starting VB/SQL Project

I am just in the process of learning VB.NET so that I can upsize an access database that I developed for my company.

I need advise on two subjects:
First, I am going to be starting a new VB.NET / SQL project using MSDE installed on my development computer. What do I need to do to allow me to easily deploy the program on several workstations and a dedicated server once development is finished?

Second, I would like to have a transitional period where both the VBA in the current MDB and the new VB.NET project access the same data. The one solution that I came up with was creating queries on the SQL server that pointed to the MDB, then once I am comfortable with the VB.NET end of things I would transfer the data it's self to the SQL server and change the queries to point to the new data location... However I have no idea weather or not this will work or if it is even close to being a good idea.

Any advice would be greatly appreciated.I wouldn't waste my time on developing in Access and then moving to SQL Server. Just start with the latter!|||Michael Kaiser

Brett Smith

Geez I thought I was unique...

Anyway, take rdjabarov's advice...

You can easily set up an Access mdb and link the sql server tables to it...

Don't bother with Jet...or don't you have sql server installed yet?

Or is it an existing application already?

How big is the database (or how big will it be?)

Also, you don't mention anything about stored procedures...

Do you plan on using them...it would be a big plus, especially for you're design implementation...|||Absolutely. Creating queries in SQL Server that point to data in a transitional Access database is going to cause you more trouble than just building the tables in SQL Server to begin with.

Hey, I like Access a lot, but there is really no point in using it in your development if it is not going to be part of your final solution.

If your data is already in Access, then it is worth trying the Upsizing wizard. I've used it once or twice and I seem to recall that it did a decent job. If you need a transitional application, then move your existing forms and code into a Microsoft Access Data Project that is tied directly to your SQL server database.|||Unfortunately I am already up to my eyeballs in Access
This is at the moment the primary issue tracking system for the small consulting firm that I work for. Hundreds of contacts, thousands of related records... and it has only been in use for about 6 months.

What I need to do is develop the project in vb and slowly transfer functionality over as modules get debugged.

To answer the other question about stored procedures, I am definitely going to be using them.|||I'm a little confused (and that's on a good day)...

Is the data centraly located, or does each client have their own copy of the data?|||Then again, I think you would be best off if you transfered the data to Microsoft SQL server and converted your Access database into an Access Data Project while you transition to your final solution.|||The data is centrally located in a mdb that only contains tables and each client has their own MDB file which has all the forms reports and VBA and links to the tables on the main database

I won't even begin to try to explain how this configuration came about, just keep in mind that decisions like that came about via committee and I (the actual developer) was not invited.|||Well, that's not a bad configuration for a distributed Microsoft Acces solution, but it does make your upsizing more difficult.

You could still develop an Access Data Project file and distribute it to your users. If you import your forms and modules it should look identical to them. Somewhere, you are going to have to bite the administrative bullet and come up with the transition strategy that best suits your business.|||I guess at this point I am going to look into an ADP, what I was hoping to avoid was spending any more time in access when it's not in the final plan. I know that the upsize wizard will not work for most of my forms and two of my tables, but I may just have to do it and get it over with|||Just another thought, would it make senct to just migrate the data to SQL and then change the links in the client MDB files to point to the SQL tables via an ODBC connection rather than actually transfer everything over to an ADP?|||I would...

a data source is a data source...

Only downside depends on the complexity of the forms/reports...

could be a lot slower depending on the # of connections opened by a form or report..|||Sure. Just make sure your security is good. Also, chances are good that you performance will be significantly slower than if you used an ADP interface.|||This is looking like my best option.

The last question on that front would be does anyone know if I like an Access MDB to SQL via ODBC can I use a SQL View for the source and meke it appear to Access to be a linked table?

I would only want to do this for two of the tables, because I would like to make some changes to the table field names.|||Yeah...check it out...they'll appear just like tables...

Just make sure that the view is updatable...otherwise it'll be a problem...|||I would get away from linked objects all together and replace them with pass-through queries to guarantee a more-or-less reasonable performance (I still don't understand why you would want to stick to Access to be your middle man.)

And to answer your question, - yes you can set a view as a source for a linked object.|||I think I am on my way!

I am sure that I will be back soon with other questions, but this should at least allow me to get my data onto SQL wile making very minor changes to the current Access database.

I need help in design?

I am trying to create a database that is used to create/store estimates for a manufacturing company. There are many things to consider in this estimate but I will isolate this question to the takeoff itself:

There are several categories in which costs are estimated and they are as follows : Product(s), Site Work, Transportation (Shipping), Field Materials, etc...

Should each of the above have their own "Takeoff" table, or would using one table and a gategory table be a better way to go?

Mike BAre these all products? If so, I would use one table with a category column, probably need more info to give better advice.|||Originally posted by rhigdon
Are these all products? If so, I would use one table with a category column, probably need more info to give better advice.

No they are not all products but, the take off list has the following items

Item | Description | Quantity | Cost | Sub-Total | %adj. | &adj. | Total

So, if I create identity columns on the source tables with the use of categories to create a surrogate key...?

tbProduct
Entry (FK) | ProductID (PK) | Account | etc...
----------------
1 | DT101A | 2301 | ....

tbTransportation
Entry (PK)| Company | Rate
----------
1 | 1 | 450

tbCategories
Category | Description
--------
1 | Product
2 | Transportation

tbTakeoff
Estimate (PK) | Entry (fk) | Category (fk) | Quantity | Cost | ......
------------------------
1000 | 1 | 1 | 1250 | 11.25 |.....
1000 | 1 | 2 | 2 | 450 |...

What do ya think?

Mike B

i need help

XYZ Company is a Car production company. It has four factories and many distribution outlets spread across the country. The company keeps online records of the sales of its cars. It also creates batched Production schedules on the basis of the sales of the car. The car production is done at a nearest factory so that the cost of transfer of cars to distribution centre is minimized. Each factory also maintains its inventory. The company maintains a distributed database management system keeping all the above information. The following information may be stored in the Distribution and Inventory Management System of the Company:

(Please note that the following description may lead to un-normalized relations, normalize them wherever required. You may also add more tables as per your analysis.)

Data store NameDescription
Distribution OutletsIt includes outlet code, outlet name, outlet address, list of car models, sales made for each model etc.
Factory It may be keeping information about each car inventory items (Model wise). It includes item code, item name, model in which this item is used, quantity used in a single Car unit, and quantity in stock, time taken to produce a batch of 100 cars, etc. This information is stored factory wise. Each factory will have separate minimum stock and reorder level based on its capacity.
Batched OrderIt includes details on overall sales of Cars at various outlets, all such sales are put together to generate a consolidated orders for factories. On the basis of such orders the factories make Cars.

Assume that only following two applications exists:

(a)Keeping track of status of Inventory so that the delays in production of Cars can be minimised. Proper reorder levels should be kept so that a given order of cars is completed with full assembly load in desired time.

(b)It evaluates the performance of each distribution outlet of the Company.
Design a distributed database assuming that at present the company has only 10 outlets. Also assume statistics, which justifies your design.

Your design should include:

(i)The global schema, fragmentation schema and allocation schema.
(ii)SQL commands/ application code for above queries/applications.
(iii)How the response for application 1 and 2 will be generated? Assuming these are global queries, explain how various fragments will be combined to generate the query response.
(iv)Implement the database at least using a centralized database management system (make suitable adjustments in your design).It looks like it is your school assignment.
Show us some work and where you have a problem.|||Kindly post what you have tried so far .