microsoft sql

sammycent

Beta member
Messages
1
pls i want to no how a db designed in a particular sys. can be uploaded into anthoer sys which has mssql installed. tanx
 
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
 
Back
Top Bottom