Go Back   Computer Forums > General Computing > Programming
Join Computer forums Today

Thread Tools Search this Thread Display Modes
Old 09-02-2009, 06:44 AM   #1
Beta Member
Join Date: Sep 2009
Posts: 1
Default microsoft sql

pls i want to no how a db designed in a particular sys. can be uploaded into anthoer sys which has mssql installed. tanx

sammycent is offline   Reply With Quote
Old 09-02-2009, 11:18 AM   #2
Site Team
root's Avatar
Join Date: Mar 2004
Posts: 7,872
Default Re: microsoft sql

export the current database as SQL and then run the SQL that is generated on the other system.

you'll need to make sure that the commands and synta are appropriate for MS SQL however,

most databases will have an option to let you export as SQL.

that'll make a text file that looks a bit like this.

create database "temp";
create table test(name varchar(255), age int);
insert into test (name, age) values ("john", "15");
insert into test (name, age) values ("tom", "16");

that was off the top of my head, and I'm fairly sure that it wouldn't actually work in any SQL editor as it's a mix of MYSQL and MSSQL style of scripting.

but you get the idea...
export as a query from one database, then run that query on the other server that you want to create the database on, sometimes the only difference between the sql styles is comments, or using ' or ` or " etc, so you could use a text editor to find and replace these to make the formatting correct if the SQL you export doesn't just run straight off on the other server

I didn’t fight my way to the top of the food chain to be a vegetarian…
Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns.
"The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."
root is offline   Reply With Quote
Old 09-03-2009, 11:50 AM   #3
Solid State Member
Join Date: Sep 2009
Posts: 6
Default Re: microsoft sql

Are you exporting from MySQL to MySQL ? And on what systems are the databases running ?
j.mizzi11 is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

All times are GMT -5. The time now is 02:39 PM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2016, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0