Have a look at the Sybase Migration Assistant provided by Microsoft:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=f39d6150-e611-46e1-84c5-0808010711c8&displaylang=en

One of the pre-reqs:

• The Sybase OLE DB provider and connectivity to the Sybase ASE database server that contains the...

princa (6/16/2011)

---

Lowell (6/16/2011)

---

yes, opc.three's comment is the key; i testest it to make sure...for me i created a suite of tables and then 4 different functions and procs, all with...

No. That's an unfortunate property of IDENTITY columns you bump up against when you want to change your schema. They are bound to...

sateswar_sahu (6/16/2011)

---

Hi All,

I've an application, which uses SYSBASE as back end. Now I want to use SQL Server 2008 and want to transfer entire database to MS SQL 2008.

I...

OK, well I feel better. At the...

carsten.jorgensen (6/16/2011)

---

Hi Orlando,

We have now retried the changes in production enviroment - doing one step at a time and testing the application afterwards.

As soon as we changed ownership of schema...

I think you had it Thomas, save for some sorting:

-- expected results from original post for 1875 as a tabular resultset

SELECT 1589381 AS ShopID,1875 AS CurrShopID,'BUNNPRIS LAMBERTSETER' AS ShopName,1422021...

I agree, PowerShell is neat like that. I am happy you found a solution 🙂

Hmmm...maybe I need to plug in over there...I have never used Twitter for tech questions.

Can you explain...

Wow...you're still asking for rope 😛

If all your data follows your example data and all you're trying to do is account for a missing 'BLVD' here and there you can...

PostgreSQL (PGS) actually offers a far more feature-complete database engine than MySQL. In terms of PGS's query optimizer, locking mechanisms, push for ANSI-SQL compliance and language features/extensions it rivals, and...

The question comes up on these forums regularly and and trying to match addresses using T-SQL language features is a losing proposition. Now that you have revealed more about what...

Cool (that you got it working, not that syntax ;-)) thanks for posting a solution!

Sorry, out of ideas. Hopefully it's not a bad install.

The things I think about sometimes while on my commute home...here is a much more efficient version of the script that only writes the final file once and only reads...