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."