Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Suggestion of a SQL Server Book
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01554954
Message ID:
01555064
Views:
56
Yes, it makes it easy, but again, you can't use the power of each server. You have to keep things very generic.

The other thing to be careful with is null.

>I started to do that once and backed out of it 1/2 though. What I've done in the past is be reaaaaly really careful how I design the tables and database - then use remote views for everything. If all is designed properly, switching between different backends (VFP, Oracle, mySQL, SQL Server) it as easy as changing one connection string. Tricky things to watch for - date, datetime, and boolen fields...and I also avoided stored procedures.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform