SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL server 7


SQL server 7

Author
Message
someone83
someone83
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 11
Dear All,

I am doing a repointing of the target table in SQL server to another ODBC destination. The problem is, if i were to specify a new target ODBC destination, i have to do the repointing of each column(in the transformation job) to the new target column. There are about 200 jobs and each tables has many columns.

Besides this manual and tedious process, would like to seek your expertise or by experience, is there any other simpler yet automated way to perform this task?
Jim Murphy
Jim Murphy
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1251 Visits: 1265
You didn't give near enough detail as to what you are doing and what you need. What is being repointed to the table, and which technology are you using?

Is the pointing done in a c# or vb6 app, or something internal to SQL server like a view to a linked server's table or a DTS package?

It sounds like you have jobs which execute DTS packages. You mention transforming in the job, but I'm wondering if you mean the job starts the DTS package, which then performs the transformation. Or does the job actually perform a transformation using TSQL code?

Which technology is used for the new odbc datasource which is the new home for the table? Another SQL Server of a different version? MySQL? Access?

So many questions that need answering first, then we can help you come up with a plan to solve this.

Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
someone83
someone83
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 11
Hi Jim,

Thanks for replying me. Sorry for the lack of details.
Its a dts job, retrieving data from source systems , transforming it and mapped into tables in the sql server. Now, all remains, except the final mapping to the tables that resides in sql server shall be changed to greenplum server.

If i were to do it manually, changing the final target odbc connection, remapping each fields, it would be very tedious.

Do you have any brilliant idea to perform this task in an automated way?
Jim Murphy
Jim Murphy
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1251 Visits: 1265
I'm afraid not. If there were any tools that auto-remapped these, they most certinly wouldn't work with SQL7 since it is so old. Most tools easily work with 2005, and a lot support 2000. But almost none work on 7.0 or before.

This is a real problem for me since I still support a sql7 installation for a health care company with their main database being 325GB and 450 concurrent users. Although not a problem for newer versions of SQL, 325GB was pretty huge for SQL server back in 1998. So I need to care for this box the old fashioned way (perfmon and server side traces).

Maybe someone else knows of a tool for you.

Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
someone83
someone83
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 11
Yeap. Its very old version of sql server. Thanks for your inputs anyhow. I will continue to search for better way and will let you know if i found better ways to do it.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search