The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Another problem with date fields
Posted: 07 Jun 07 3:06 PM
|
| I just found another problem where legacy code is entering dates NOT in ISO format, so the data is not synching to users. Since almost all of the remote users are in the office from time to time, I have solved this in the past by using DTS to copy the tables to the remote when they are in the office. However, we have recently upgraded to SQL Server 2005, and I cannot connect to MSDE any longer from the Development Studio (funny thing is that I can connect from SQL Management Console). Anyone have any quick ideas for me, short of re-cutting all of the databases? I was thinking of using the provider to copy all of the data to a temp table, then deleting the table, and copying the data back to the original table with the dates converted to ISO format. Better ideas? |
|
|
|
Re: Another problem with date fields
Posted: 07 Jun 07 7:28 PM
|
Did you try...
-Backup the MSDE database then restore into a database on the SQL2005 server.
-Grab the MDF file from the remote and attach it to a SQL2005 database. |
|
|
|
Re: Another problem with date fields
Posted: 07 Jun 07 11:05 PM
|
| You can't connect to MSDE from SQL Management Studio (as in register it as a server), but you can use SSIS to connect to a MSDE target. A connection in SSIS can be to anything, it can be MSDE or anything else. KWIM? |
|
|
|
Re: Another problem with date fields
Posted: 08 Jun 07 7:05 AM
|
Time to fix the code!
I've found in 100% of the upgrades I've excuted where there are legacy customizations.. there is bad code when it comes to datetime. Also, found datetime fields bound to Text controls, etc.. not good.
You have to fix them all.. takes time.
--
rjl |
|
|
|
Re: Another problem with date fields
Posted: 08 Jun 07 8:16 AM
|
| Actually, I've found the reverse to be true. I can register it as a server in SQL Management Console, but I have been unable to connect in SSIS. I've tried ADO, ADO.NET, OLEDB, And SMOServer connections, and have been unable to get any of them to work. Come to think of it, I only tried OLEDB with Native SQL provider. Maybe I should try the SalesLogix provider? |
|
|
| |
|
Re: Another problem with date fields
Posted: 09 Jun 07 11:31 AM
|
We have a "tool" (and a "process") to sync out any table (or sync it "back"....) It's part of out "IP"... get in touch w/me.
--
rjl |
|
|
|