Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 MS SQL Query.
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 11 January 2007 :  16:08:31  Show Profile  Visit spyderuk's Homepage
Things are not working out with my new host and the "too good to be true" pricing has it's downfalls and plenty of downtime.

As my database was converted to MY SQL would it be an easy procedure to transfer to MS SQL. I would prefer to keep all post's etc from my last transfer less than 2 weeks ago.

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 11 January 2007 :  20:09:01  Show Profile  Send ruirib a Yahoo! Message
Never did it like that, but it should be possible, yes. You should use a similar procedure... create the blank tables, run all dbs files and then transfer the data.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 12 January 2007 :  03:29:25  Show Profile  Visit spyderuk's Homepage
quote:
Originally posted by ruirib

Never did it like that

Rui, Sorry I don't understand.

Anyway, it's not working out on that server you did the transfer on.
My question in this topic is about converting from MYSQL - MSSQL.

My Access file is now out of date and obviously doesn't contain the recent data.

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 12 January 2007 :  03:50:31  Show Profile  Send ruirib a Yahoo! Message
I meant I never migrated from MySQL to SQL Server, but respecting the conditions I stated, it should be possible.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

spyderuk
Junior Member

United Kingdom
211 Posts

Posted - 13 January 2007 :  04:26:34  Show Profile  Visit spyderuk's Homepage
Sorry, my bad Understand your statement now.

Replied to your email

Snitz 3.4.05. Mods Installed, Additional Smilies, Poll's, PM's, Email All Users, Today/Yesterday, Active Users 4, Portal Mod, My Own Google, Referer Mod, Avatars, Intergrated Conqueror Chat, Usergroups, IPGate, File Attachment Mod & Image Resize Mod.
Next Mod? My Snitz Forum
Go to Top of Page

Rtwhite
Starting Member

USA
27 Posts

Posted - 30 January 2007 :  17:14:59  Show Profile  Visit Rtwhite's Homepage
I am brand new at this. I have been wanting to be able to add forums to a website or two that I created and maintain. I'm not the best web designer in the world, ( Some say I am close to being the worst though ),and I know nothing about SQL at all. My best bet to make this happen I have discovered is to throw myself on the mercy of someone that IS actually intelligent and beg for help and patients. Anyone willing ?
Thanks so much, robert@dts-computers.com
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 30 January 2007 :  22:19:31  Show Profile  Visit AnonJr's Homepage
1 - if you're going to "beg for help and patients" you really ought to start a new topic. People who would otherwise help might pass over the topic because of its title. Also, your request doesn't seem to fit the rest of the thread...

2 - we really try to "raise up" those who wouldn't normally do stuff like this. Give it a shot and see how far you can get. If you run into a problem, be specific. The best way to get help is to be specific in what the problem is and what you need to get resolved.

If you at least try and then get really stuck, people here will help. Good luck.
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 31 January 2007 :  09:42:08  Show Profile  Send pdrg a Yahoo! Message
RTWhite - as AnonJr says, start a new topic with lots of description, and examples of what you've tried/done so far. This will encourage people to respond as they will see it as a new problem, and have enough information to be able to help you.

And again, as AnonJr says, you will get far better help if you demonstrate that you're trying to learn as you go - tell us if you've read the FAQ, tell us if you've googled for some specific info, etc. A lot of the guys here are hardcore IT professionals, ie paid well by companies for their knowledge, and volunteer here as a way to help others learn - so helping you learn is for free, doing something for you which you could do yourself is a professional service (ie in the real world you'd be charged for it!)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000 Version 3.4.07