morning
i'm sure in the past i've managed to get sql to create population strings (as a file) that you can run and it simply inserts all the data as needed.
i have a development server in house and a soon to be live server at the client, in a rush twenty to five mad dash we were trying to create our environment on the client machine but were having no luck with using sql backups from our system to create databases on the client.
ended up creating the scripts through sql to build the tables needed but obviously have no data.
in the past i'm sure i've exported scripts from sql that populate tables ie.
insert into table1 (field1, field2) values (0,'test1')
insert into table1 (field1, field2) values (1,'test2')
just can't completely remember, would be nice to find this as we have about 20 - 30 dimension tables to update, don't fancy typing each and every record in!!!!
any ideas?
cheers
davej
daveJam
*two wrongs don't make a right..... but three lefts do!!!!*
i'm sure in the past i've managed to get sql to create population strings (as a file) that you can run and it simply inserts all the data as needed.
i have a development server in house and a soon to be live server at the client, in a rush twenty to five mad dash we were trying to create our environment on the client machine but were having no luck with using sql backups from our system to create databases on the client.
ended up creating the scripts through sql to build the tables needed but obviously have no data.
in the past i'm sure i've exported scripts from sql that populate tables ie.
insert into table1 (field1, field2) values (0,'test1')
insert into table1 (field1, field2) values (1,'test2')
just can't completely remember, would be nice to find this as we have about 20 - 30 dimension tables to update, don't fancy typing each and every record in!!!!
any ideas?
cheers
davej
daveJam
*two wrongs don't make a right..... but three lefts do!!!!*
